Find & Replace with wildcards returning original text

[Frogy]

I want to be able to part of string that was found with wild cards, but maintain the values that the wild cards replaced.

I have data that may contain strings of the following form

xxx, [abcd, efgh], xxx

I want to be able to replace this with the following string

xxx, [abcd/efgh], xxx

Where abcd and efgh will be differnt in all instances.

Would like something like

Find [*,*]
Replace [*/*]

where the replace returns the original values in the abcd & efgh positions.

I don't care if it is done directly in excel or in vba code.

Any ideas?

Thanks

 

[GTO]

Can we depend on always finding the brackets and that there will always be only one set of brackets?

 

[Frogy]

No, brackets may or may not exist, and there may be up to two pairs of brackets.

 

[Frogy]

Also, the abcd & efgh strings can vary in length (usually 4 - 6 characters) and there may or may not be a space after the comma.

Thanks