Format first name and last name into userid in excel
Posted on 2011-05-09
I need help with an excel spreedsheet. lets say I have 3 columns A=First Name, B=Last Name, and C=UserID. I need to take first initail in column A and the first 7 characters in column B and combine them in C. So if I have a Terry Massengill the UserID would be massengt. The UserID would be formated lastname first initial. But only a total of 8 characters. Any help would be appreciated.