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. Max, In another column use a formula like =LEFT(A1,1)&"0"&MID(A1,3,LEN(A1)) "Max" <anonymous@discussions.microsoft.com> wrote in message news:6D20B13F-BDDE-4704-B5AC-337648E23929@microsoft.com... > 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. How can I treat th...