alpha numberic cell

[clambake5]

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

 

[CLR]

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

 

[Max]

Another way to try out ..

Put in any starting cell, say A2:

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

Copy A2 down

 

[CLR]

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

 

[Max]

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")

 

[clambake5]

Thanks Max! You are a bloody genius!!

Another way to try out ..

Put in any starting cell, say A2:

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

Copy A2 down

 

[Max]

Glad to hear it worked !
Thanks for the feedback ..