auto numbering

[BHScripter]

Hi:

I want to create id's for rows of data. each line needs to be 8 characters, alpha numeric starting with 'vat'

So, I want the first row to be:

vat00001 then the second row would be
vat00002 and so on

How can I get excel to auto generate these values?

Best,
Brianna

 

[Zathras]

If this is just a one-time thing, I would put this formula in A1:
[tt]
="vat"&RIGHT(100000+ROW(),5)
[/tt]
and copy it down as far as needed. Then I would finish by doing a Copy and Paste/Special Values.

 

[BHScripter]

that worked great

 

[Crystalyzer]

A much easier solution would have been to simply type "vat00001" in a cell and "vat00002" in the cell just below it, highlight both cells with the mouse, grab the lower right hand corner of the selection and drag it down as many rows as you want. Excel will do the rest and no complicated formula or copy and pasting required!


Thanks and best regards,
-Lloyd