find and replace parens
 

I need to do a find/replace on cell contents that contain something similar
to: California Avenue Dialysis (fka Bakersfield)
End result s/b California Avenue Dialysis.

The placement of the text in parens are not always at the beginning or end
of the cell.
I tried using ?fka, but that only removes the(fka

Thank you!
Cathy

find and replace parens
 

Ctrl + h

find what

(*)


leave replace with box empty


use a help column and a formula


=TRIM(SUBSTITUTE(A1,MID(A1,FIND("(",A1),FIND(")",A 1)+1-FIND("(",A1)),""))

copy down/across, then copy and paste special as values




--
Regards,

Peo Sjoblom

"Cathy Landry" wrote in message
...
I need to do a find/replace on cell contents that contain something similar
to: California Avenue Dialysis (fka Bakersfield)
End result s/b California Avenue Dialysis.

The placement of the text in parens are not always at the beginning or end
of the cell.
I tried using ?fka, but that only removes the(fka

Thank you!
Cathy

find and replace parens
 

That was just tooooo easy!

Thank you!

"Peo Sjoblom" wrote:

Ctrl + h

find what

(*)


leave replace with box empty


use a help column and a formula


=TRIM(SUBSTITUTE(A1,MID(A1,FIND("(",A1),FIND(")",A 1)+1-FIND("(",A1)),""))

copy down/across, then copy and paste special as values




--
Regards,

Peo Sjoblom

"Cathy Landry" wrote in message
...
I need to do a find/replace on cell contents that contain something similar
to: California Avenue Dialysis (fka Bakersfield)
End result s/b California Avenue Dialysis.

The placement of the text in parens are not always at the beginning or end
of the cell.
I tried using ?fka, but that only removes the(fka

Thank you!
Cathy