Change 2 digit suffix in 14 digit number in a column of numbers.

  • Thread starter Thread starter Brad H.
  • Start date Start date
B

Brad H.

How do you change a 2 digit suffix on a 14 digit number
(in numeric format) in a column of numbers with the same
suffix, i.e. want to change the whole column's year
designator from xxxxxxxxxxxx02 to xxxxxxxxxxxx03?

Looked in 4 sources and couldn't find that one. Can it be
done? Must be a way!

Thanks anyone that can share the answer.
 
If you didn't have any 99's left, you could put 1 in an empty cell.
Copy it
Select your range
Edit|Paste special|check Add in operation portion
clean up that 1

If you still had 99's, then this won't work without adjusting the 3rd digit in.
 
Back
Top