• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • Last Modified:

Format first name and last name into userid in excel

Hello everyone

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.  
0
CFT-TN
Asked:
CFT-TN
  • 3
1 Solution
 
Brian GeeCommented:
Put this in cell C1 and then copy down.

=LEFT(A1,1) & LEFT(B1,7)
0
 
Brian GeeCommented:
Sorry, this way instead for last then first.

=LEFT(B1,7) & LEFT(A1,1)
0
 
Brian GeeCommented:
If you needed all the letters in lowercase like your example noted originally, try:

=LOWER(LEFT(B1,7) & LEFT(A1,1))

All uppercase would be:

=UPPER(LEFT(B1,7) & LEFT(A1,1))
0
 
chwong67Commented:
=lower(LEFT(B1,7) & LEFT(A1,1) )
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now