Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am working on a spreadsheet where I have a need to find 3 different items
and replace them with the first item as follows: Smith A B C Jones A C Green B C It needs to come out like this: Smith Smith Smith Smith Jones Jones Jones Green Green Green Any thoughts? Thanks in advance for all insights and help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
VB Find and Replace | Excel Worksheet Functions |