alpha numberic cell

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Another way to try out ..

Put in any starting cell, say A2:

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

Copy A2 down
 
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
 
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")
 
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...
 
You must log in or register to reply here.

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

search for text then add 3
Alphanumeric Sorting - numeric alpha numeric 2
Column Headings 3
Pivot Tables: Don't show data for detail, but still show subtotals 3
Prevent alpha character from being entered into a numeric field 3
How to seperate ALPHANUMERIC data in a cell in an excel sheet. 3
Excel Excel IF variable based on time of day 0
formula adding range of cells that contains alpha numeric 1

Back
Top