Replacing numbers

[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

 

[Don Guillett]

select the data>edit replace>209 >210
Just make SURE that 209 doesn't exist anywhere else

 

[Eduardo]

Hi,
Highlight the column where you have the numbers, hit Ctrl H, find what enter
209,
replace with enter 210, replace all

 

[Randy B.]

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

 

[Randy B.]

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

 

[Eduardo]

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