G Guest Jun 4, 2004 #1 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.
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.
C Chip Pearson Jun 4, 2004 #2 Max, In another column use a formula like =LEFT(A1,1)&"0"&MID(A1,3,LEN(A1)) Max said: I have a column of 8 charecters just like the above one Click to expand... "0N125415". What should I do to convert the second Charecter into "0"?
Max, In another column use a formula like =LEFT(A1,1)&"0"&MID(A1,3,LEN(A1)) Max said: I have a column of 8 charecters just like the above one Click to expand... "0N125415". What should I do to convert the second Charecter into "0"?
G Guest Jun 4, 2004 #3 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) Max said: I have a column of 8 charecters just like the above on Click to expand... "0N125415". What should I do to convert the second Charecter int "0"
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) Max said: I have a column of 8 charecters just like the above on Click to expand... "0N125415". What should I do to convert the second Charecter int "0"
D Dave Peterson Jun 5, 2004 #4 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.
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.
