alpha numberic cell

How do I create an alpha numeric cell example NAR 1.00 then NAR 2.00?

In A1 type 1 and Enter, then highlight A1 > right-click > FormatCells >
Number tab > Custom > and in the Type: window, NAR 0.00 > OK.......then in
A2 put =A1+1 and copy down...........

Vaya con Dios,
Chuck, CABGx3


"clambake5" <clambake5@discussions.microsoft.com> wrote in message
news:EE5610E2-35C9-46FF-B2BC-A5F6B9A85FC8@microsoft.com...
> How do I create an alpha numeric cell example NAR 1.00 then NAR 2.00?

Another way to try out ..

Put in any starting cell, say A2:

="NAR "&TEXT(ROWS($A$1:A1),"0.00")

Copy A2 down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"clambake5" <clambake5@discussions.microsoft.com> wrote in message
news:EE5610E2-35C9-46FF-B2BC-A5F6B9A85FC8@microsoft.com...
> How do I create an alpha numeric cell example NAR 1.00 then NAR 2.00?

Another way...........

in A1 type NAR 1.00
in A2 type =LEFT(A1,3)&" "&TEXT(MID(A1,FIND(" ",A1,1),99)+1,"0.00") and copy
down.........

Vaya con Dios,
Chuck, CABGx3


"clambake5" <clambake5@discussions.microsoft.com> wrote in message
news:EE5610E2-35C9-46FF-B2BC-A5F6B9A85FC8@microsoft.com...
> How do I create an alpha numeric cell example NAR 1.00 then NAR 2.00?

And if you want to fill across instead of down,
just change ROWS to COLUMNS,
viz. use: ="NAR "&TEXT(COLUMNS($A$1:A1),"0.00")

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

Thanks Max! You are a bloody genius!!


"Max" wrote:

> Another way to try out ..
>
> Put in any starting cell, say A2:
>
> ="NAR "&TEXT(ROWS($A$1:A1),"0.00")
>
> Copy A2 down
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "clambake5" <clambake5@discussions.microsoft.com> wrote in message
> news:EE5610E2-35C9-46FF-B2BC-A5F6B9A85FC8@microsoft.com...
> > How do I create an alpha numeric cell example NAR 1.00 then NAR 2.00?
>
>
>

Glad to hear it worked !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"clambake5" <clambake5@discussions.microsoft.com> wrote in message
news:C3EF6992-0977-4FAF-A598-8CA390B1EB4B@microsoft.com...
> Thanks Max! You are a bloody genius!!