Help with a simple formula
Thanks soooooo much.
"Toppers" wrote:
with value in A1:
in B1:
=LEFT(A1,9) & "1" & RIGHT(A1,2) &"41"
Copy down
HTH
"Byron720" wrote:
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
"Toppers" wrote:
3175AAA01 01
3175AAA01 10141
What exactly to change .... 01 to 10141? or
3175AAA01 01 to 3175AAA0101000?
"Byron720" wrote:
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
|