Replacing numbers

  • Thread starter Thread starter Randy B.
  • Start date Start date
R

Randy B.

I have a spreadsheet which contains 6 digit numbers (i.e.209111, 209112,
209113).
I would like to perform a bulk replace for just the first 3 numbers.
Turn 209*** into 210***.
Any suggestions?
Thanks,
Randy
 
select the data>edit replace>209 >210
Just make SURE that 209 doesn't exist anywhere else
 
Hi,
Highlight the column where you have the numbers, hit Ctrl H, find what enter
209,
replace with enter 210, replace all
 
Worked.
Thank you very much. I was trying to use * to place hold for the last 3
numbers and it didn't work.
Thanks again.
Randy
 
Worked.
Thank you very much. I was trying to use * to place hold for the last 3
numbers and it didn't work.
Thanks again.
Randy
 
Thank you for the feedback, if you click in the yes buttom to the question if
this was helpful will help others to get the answer , thank you
 
Back
Top