Mitch, something like this should work: Column A = last name, Column B = first name, Column C = year of graduation
A B C 1 Mueller Mitch 2010 2 Stanzel Matt 2011 =SUBSTITUTE(TRIM(UPPER(CONCATENATE(LEFT(A2,1)),A1,RIGHT(A3,2)))," ","") The "Substitute" portion will remove spaces from the username and replace with no space. -----Original Message----- From: Mitch Mueller [mailto:mmuel...@emmetsburg.k12.ia.us] Sent: Tuesday, August 04, 2009 8:28 AM To: info-tech@aea8.k12.ia.us Subject: [info-tech] Excel Help I hope Trying to write a excel function. Wanting to make a csv file and need to make a fuction that reads. Username is first initial, last name and than if their grade it 12 it corresponds to the year they graduate. So it would look like mmueller10 If you have any idea on what we could do for that it would be awesome cause I don't want to have to go through all of our student and add than manually if I didn't have too. Thanks Mitch Mueller Emmetburg CSD --- [This E-mail scanned for viruses by Declude Virus on the server aea8.k12.ia.us] --------------------------------------------------------- Archived messages from this list can be found at: http://www.mail-archive.com/info-tech@aea8.k12.ia.us/ --------------------------------------------------------- --- [This E-mail scanned for viruses by Declude Virus on the server aea8.k12.ia.us] --------------------------------------------------------- Archived messages from this list can be found at: http://www.mail-archive.com/info-tech@aea8.k12.ia.us/ ---------------------------------------------------------