Format first name and last name into userid in excel

Posted on 2011-05-09
Medium Priority
Last Modified: 2012-06-21
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.  
Question by:CFT-TN
  • 3
LVL 23

Expert Comment

by:Brian Gee
ID: 35725351
Put this in cell C1 and then copy down.

=LEFT(A1,1) & LEFT(B1,7)
LVL 23

Expert Comment

by:Brian Gee
ID: 35725360
Sorry, this way instead for last then first.

=LEFT(B1,7) & LEFT(A1,1)
LVL 23

Accepted Solution

Brian Gee earned 2000 total points
ID: 35725375
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))

Expert Comment

ID: 35725384
=lower(LEFT(B1,7) & LEFT(A1,1) )

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question