This gets me somewhere but I'm not getting anywhere with it. I think you made some mistakes and I'm trying to figure them up.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stanzel, Matt Sent: Tuesday, August 04, 2009 8:43 AM To: [email protected] Subject: RE: [info-tech] Excel Help I hope 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:[email protected]] Sent: Tuesday, August 04, 2009 8:28 AM To: [email protected] 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/[email protected]/ --------------------------------------------------------- --- [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/[email protected]/ --------------------------------------------------------- --- [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/[email protected]/ ---------------------------------------------------------
