alphanumeric sku numbers
 

How can I get excel to generate alphnumeric skus?

AA-0001
AA-0002
AA-0003

alphanumeric sku numbers
 

Hi,

In any cell as the starting point, enter the following formula, and drag to
fill down the column.

=IF(ROW(A1)999,"AA-",IF(ROW(A1)99,"AA-0",IF(ROW(A1)9,"AA-00","AA-000")))&ROW(A1)

Hope ithis helps,

Regards,
B. R. Ramachandran

"Cblaine" wrote:

How can I get excel to generate alphnumeric skus?

AA-0001
AA-0002
AA-0003

alphanumeric sku numbers
 

In any starting cell,
say in B3: ="AA-"&TEXT(ROWS($1:1),"0000")
Copy down. Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Cblaine" wrote:
How can I get excel to generate alphnumeric skus?

AA-0001
AA-0002
AA-0003

alphanumeric sku numbers
 

Do you mean you want to generate sequential SKUs? If so, enter one of them
into a cell, then drag that cell down by the fill handle. Done. HTH Otto
"Cblaine" wrote in message
...
How can I get excel to generate alphnumeric skus?

AA-0001
AA-0002
AA-0003

alphanumeric sku numbers
 

"Max" wrote:

In any starting cell,
say in B3: ="AA-"&TEXT(ROWS($1:1),"0000")
Copy down. Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Cblaine" wrote:
How can I get excel to generate alphnumeric skus?

AA-0001
AA-0002
AA-0003

alphanumeric sku numbers
 

Hi Max,

Very nice formula!

A variation:
="AA-" & TEXT(ROW(A1),"0000")

Regards,
B. R. Ramachandran

"Max" wrote:

In any starting cell,
say in B3: ="AA-"&TEXT(ROWS($1:1),"0000")
Copy down. Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Cblaine" wrote:
How can I get excel to generate alphnumeric skus?

AA-0001
AA-0002
AA-0003

alphanumeric sku numbers
 

Hi,

Just type AA-0001 in one cell and then drag down the fill handle (corner
right). Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Cblaine" wrote in message
...
How can I get excel to generate alphnumeric skus?

AA-0001
AA-0002
AA-0003