find and replace parens

G

Guest

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
 
P

Peo Sjoblom

Ctrl + h

find what

(*)


leave replace with box empty


use a help column and a formula


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

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

Guest

That was just tooooo easy!

Thank you!

Peo Sjoblom said:
Ctrl + h

find what

(*)


leave replace with box empty


use a help column and a formula


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

copy down/across, then copy and paste special as values
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace variable string 11
find part text, replace all text 4
Find and Replace Troubleshoot 6
Find and replace a value within a formula 2
End/Beginning of Cell Search/Replace? 1
Find and Replace based on neighboring cells? 4
Find and Replace only the end of a cells text 3
Find and Replace 1

Top