alpha numberic cell

C

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
 
M

Max

Another way to try out ..

Put in any starting cell, say A2:

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

Copy A2 down
 
C

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
 
M

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

clambake5

Thanks Max! You are a bloody genius!!


Max said:
Another way to try out ..

Put in any starting cell, say A2:

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

Copy A2 down
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Booklet in Word, Merge Directory from Excel 0
Need help merging Excel into Publisher Booklet w 2 columns 0
Assistance in modifying a formula 0
Hyperlinks with lookups 0
Autofill alphanumeric prefix in Excel 3
Setting a range in a named range 3
SUM Char 9
search for text then add 3

Top