If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.

Let's suppose your names are in column A.
In B1, enter:
=LEFT(A1,3) and fill down
In C2, enter:
=IF(LEFT(A2,3)=B1,C1+1,0) and fill down
In D2, enter:
=B2&"00"&TEXT(C2,"00") and fill down

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Maltenrazer" > wrote in message
...
>
> hi, i need help i am a college student, i am creating a spreadsheet for
> my portfolio
>
> i would like to generate ID numbers for students in a spreadsheet i am
> doing.
>
> so what i want to do is take the first 3 letter of a students name then
> add 00 ,and then it should , generate numbers from 1-90 , than i could
> use this as an id number.
>
> e.g
>
> *Dav*id
>
> DAV0056
>
> "dav" in the first part is from the name, the two zero are just put in
> and then i want numbers from 1-90 to be inputed.
>
> i have 90 students names that i need to create Unique ID numbers. so
> please can you tell me the formula/function on how i can do this.
>
> thank you for your help in advance..
>
>
> --
> Maltenrazer
> ------------------------------------------------------------------------
> Maltenrazer's Profile:
> http://www.excelforum.com/member.php...o&userid=16130
> View this thread: http://www.excelforum.com/showthread...hreadid=275688
>

and fill down with no intermediate formulas in columns B or C. This
assumes OP wants the serial number portion of the IDs not to reset when
the partial name protion changes. If s/he does want resetting to 0001
rather than 0000, then