Extracting text before and after special character simaltaneously.

[chrisneedshelp]

Hi,

I am trying to extract text from a cell to reformat and remove some parts.

Jones, John (London) would want to be changed to John Jones

I have tried using the LEFT/RIGHT/MID and SEARCH formulas but i have not been able to tweak it to correctly show what i want.

Can you please help

 

[Fluff]

How about
=TRIM(MID(SUBSTITUTE(A2,"(",REPT(" ",100)),SEARCH(",",A2)+2,100))&" "&LEFT(A2,SEARCH(",",A2)-1)