Help with a simple formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of numbers like this 3175AAA0101. I need to convert them all to
this format: 3175AAA0110141. How do I do it?

Byron
 
3175AAA01 01
3175AAA01 10141

What exactly to change .... 01 to 10141? or

3175AAA01 01 to 3175AAA0101000?
 
Correct: I want to replace the last two digits (01) with 10141. For example:

3175AAA0101 -----> 3175AAA0110141
3175XXX0806 -----> 3175XXX0810641

i want to add the number "41" at the end and the number "1" in between the
last four numbers
 
Back
Top