Format first name and last name into userid in excel
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.
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.