Home |
Search |
Today's Posts |
#1
|
|||
|
|||
generating Unique ID numbers for students
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
How to Replace numbers and text with numbers only? | Excel Worksheet Functions |