B
Byron720
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
this format: 3175AAA0110141. How do I do it?
Byron
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
3175AAA01 01
3175AAA01 10141
What exactly to change .... 01 to 10141? or
3175AAA01 01 to 3175AAA0101000?
3175AAA01 10141
What exactly to change .... 01 to 10141? or
3175AAA01 01 to 3175AAA0101000?
B
Byron720
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
3175AAA0101 -----> 3175AAA0110141
3175XXX0806 -----> 3175XXX0810641
i want to add the number "41" at the end and the number "1" in between the
last four numbers
T
Toppers
with value in A1:
in B1:
=LEFT(A1,9) & "1" & RIGHT(A1,2) &"41"
Copy down
HTH
in B1:
=LEFT(A1,9) & "1" & RIGHT(A1,2) &"41"
Copy down
HTH
B
Byron720
Thanks soooooo much.
Toppers said:with value in A1:
in B1:
=LEFT(A1,9) & "1" & RIGHT(A1,2) &"41"
Copy down
HTH