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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search And Replace Whole Words
Hi,
Columns("I:I").Select Selection.Replace What:="20", Replacement:="general damage", lookat:=xlWhole HTH "Mary H" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search And Replace Whole Words
thank you
"Toppers" wrote: Hi, Columns("I:I").Select Selection.Replace What:="20", Replacement:="general damage", lookat:=xlWhole HTH "Mary H" wrote: 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 |
Reply |
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 |