Solved

# Format first name and last name into userid in excel

Posted on 2011-05-09
Medium Priority
276 Views
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
Question by:CFT-TN
• 3

LVL 23

Expert Comment

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

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

LVL 23

Expert Comment

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

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

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))
0

LVL 9

Expert Comment

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

## Featured Post

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…
###### Suggested Courses
Course of the Month14 days, 5 hours left to enroll