| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace several words to One
Hello How do I correct the macro below. I want to change the words FXG,
FXR, GFX, and FXT to say FAX Thank you thank you Range("C1:C3169").Select Selection.Replace What:=("FXG""FXR""GFX""FXT")Replacement:="FAX", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple sets words replace | New Users to Excel | |||
| replace numbers in English words- | Excel Worksheet Functions | |||
| IF formula in Excel / Replace numbers with 'words' | Excel Discussion (Misc queries) | |||
| Replace a long list of abbreviations with full words in Excel | Excel Worksheet Functions | |||
| Excel to replace words ? | New Users to Excel | |||
Threaded Mode
