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" wrote in message
...
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 <atyahoo<dotcom
----
"clambake5" wrote in message
...
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" wrote in message
...
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 <atyahoo<dotcom
----

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 <atyahoo<dotcom
----
"clambake5" wrote in message
...
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 <atyahoo<dotcom
----
"clambake5" wrote in message
...
Thanks Max! You are a bloody genius!!