M
Max
I have a column of 8 charecters just like the above one "0N125415". What should I do to convert the second Charecter into "0"
Thanks a lot.
Thanks a lot.
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.
C
Chip Pearson
Max,
In another column use a formula like
=LEFT(A1,1)&"0"&MID(A1,3,LEN(A1))
"0"?
In another column use a formula like
=LEFT(A1,1)&"0"&MID(A1,3,LEN(A1))
"0N125415". What should I do to convert the second Charecter intoMax said:I have a column of 8 charecters just like the above one
"0"?
M
Max
How can I treat the outcome as numbers? I tried multiple ideas, didnt work
----- Chip Pearson wrote: ----
Max
In another column use a formula lik
=LEFT(A1,1)&"0"&MID(A1,3,LEN(A1)
"0"
----- Chip Pearson wrote: ----
Max
In another column use a formula lik
=LEFT(A1,1)&"0"&MID(A1,3,LEN(A1)
"0N125415". What should I do to convert the second Charecter intMax said:I have a column of 8 charecters just like the above on
"0"
D
Dave Peterson
One way:
=--(LEFT(A1,1)&"0"&MID(A1,3,LEN(A1)))
the right minus makes it a negative number, the left minus changes it back to a
positive number.
=--(LEFT(A1,1)&"0"&MID(A1,3,LEN(A1)))
the right minus makes it a negative number, the left minus changes it back to a
positive number.