Hi I have what seems like a simple question
I have a spreadsheet with a lot of item numbers on it.
All the item numbers are 3 numbers long and have 1 as the first digit.
I want to change all the first digits from 1 to 2.
For example 101,102,103,104,105,106,107,108,109,110
I want to change to 201,201,203,204,205,206,207,208,209,210
I want to find all 1?? and replace with 2?? where ?? are the original second and third digits.
The excel find and replace simply returns all "2??"
Regards
Darren
Bookmarks