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

3 Replies
285 Views

Similar Articles

[PageSpeed] 4

```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 (74721)
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