Search and replace data between wildcards

Hello guys, I need your help once more:


I have use the search and replace function in ms excel 2010 by this:

Search for: * */

and replacecwith: *,*/

the problem is that I do not want to change the random data from wildcard, I only want to change this specific Space with a comma.

So how can I do that?

Eg the original text from A1 cell was: Al Sariah vs Al Ouahnta 15/12/2015 17:30
I want to change it in to this: Al Sariah vs Al Ouahnta,15/12/2015 17:30

the problem is that the name of the teams and the date is different in every cell, so I can only search with wildcard like this: * */

Give me a formula or something like that, I can't find anything or I can not understand...

Thanks.....

UPDATE!!!

Thanks to

Originally Posted by AlKey

AlKey

the formula to do this is:

Please Login or Register  to view this content.

Try this

Formula:

Please Login or Register  to view this content.

Data Range

	A	B
1	Al Sariah vs Al Ouahnta 15/12/2015 17:30	Al Sariah vs Al Ouahnta, 15/12/2015 17:30

Originally Posted by AlKey

Try this

Formula:

Please Login or Register  to view this content.

Data Range

	A	B
1	Al Sariah vs Al Ouahnta 15/12/2015 17:30	Al Sariah vs Al Ouahnta, 15/12/2015 17:30

Thank you, it works. Is it possible to explain me how to use this formula for other problems in future???

Thank you very much.....

1. =MID(A1,FIND("/",A1)-3,11)

this formula produce " 15/12/2015"

2. =","&MID(A1,FIND("/",A1)-3,11)

which will be replaced with ", 15/12/2015"