Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find multiple cells/replace whole cells w/data
I am trying to find a specific set of characters in multiple cells in a
column. Once found, I need to replace the data within found cells with a specific text string. I have been able to replace a text string, but not the whole cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find multiple cells/replace whole cells w/data
Perform a search and replace, and add an asterisk before and after your
"search for" parameter. Replace with your desired cell contents. Search for: *your text here* Replace with: desired cell contents |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find multiple cells/replace whole cells w/data
Instead of 'Find', turn on data filters and select Custom... Use the
drop-downs to make the condition 'contains' and then enter the set of characters in the text box. Now only the appropriate rows should be shown, so type the replacement text in the first matching cell and drag it down, copying it to the remaining rows. "dcurylo" wrote: I am trying to find a specific set of characters in multiple cells in a column. Once found, I need to replace the data within found cells with a specific text string. I have been able to replace a text string, but not the whole cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find linked cells | Excel Discussion (Misc queries) | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Find values from cells in multiple sheets | Excel Worksheet Functions | |||
How to find returns in cells | Excel Worksheet Functions | |||
background formatting across multiple cells | Excel Discussion (Misc queries) |