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
|