Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search And Replace Whole Words
I am writing a program that searchs a column for code numbers and replaces it
with a descritpion of that corresponding code number. Here is an exerpt of the code Columns("I:I").Select Selection.Replace What:="20", Replacement:="general damage" The problem I am having is if there is a code 5420 or anything else that has that number in it, it replaces the 20 part with the text specified. I would like to know how to do a search and replace of a whole value. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace several words to One | Excel Discussion (Misc queries) | |||
search of words | Excel Discussion (Misc queries) | |||
replace numbers in English words- | Excel Worksheet Functions | |||
How can i find and replace words mean from one file to another?? | Excel Programming | |||
Excel to replace words ? | New Users to Excel |