You're right folks - I mis-read the OP.
This has been happening all too often lately, so I guess I'll try to get
away with it by saying that my Senior Moments are catching up with me.<bg
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
"Gary's Student" wrote in message
...
find / replace will really butcher 161616
--
Gary's Student
"pmhall" wrote:
I am using MS Office 2003 and attempting to use a wildcard to find and
replace characters within cells within a column (ex. 161000 to be
changed to
201000). In a column of such numeric values the first two digits are
consistent while the last 4 digits are not. Using the wildcard feature
in the
find and replace menu, I highlighted the column, clicked find and
replace,
"Find what = 16*, Replace with = 20*". This changed 161000 to 20*, when
I
wanted 201000. Any assistance would be greatly appreciated.
|