| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| How to ignore parens in a sort? | Excel Discussion (Misc queries) | |||
| Find and Replace | New Users to Excel | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Linear Mode
