View Single Post
  #9   Report Post  
RagDyer
 
Posts: n/a
Default

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.