Format first name and last name into userid in excel

Posted on 2011-05-09
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
    LVL 23

    Expert Comment

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

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

    Expert Comment

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

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

    Accepted Solution

    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))
    LVL 9

    Expert Comment

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

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now