Need Help "0N125415"

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. 
0
anonymous (74717)
6/4/2004 12:36:05 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
223 Views

Similar Articles

[PageSpeed] 36

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.


0
chip1 (1821)
6/4/2004 12:42:19 PM
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" <anonymous@discussions.microsoft.com> wrote in messag
     news:6D20B13F-BDDE-4704-B5AC-337648E23929@microsoft.com..
     > I have a column of 8 charecters just like the above on
     "0N125415". What should I do to convert the second Charecter int
     "0"
     >>> Thanks a lot
    
    
     
0
anonymous (74717)
6/4/2004 2:06:06 PM
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.



Max wrote:
> 
> How can I treat the outcome as numbers? I tried multiple ideas, didnt work?
> 
>      ----- Chip Pearson wrote: -----
> 
>      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.
> 
> 
> 

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
6/5/2004 12:47:01 AM
Reply:

Similar Artilces:

Need Help "0N125415"
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...