+ Reply to Thread
Results 1 to 4 of 4

Excel Forumla needed to combine first letter of first name with last name in new column?

  1. #1
    Registered User
    Join Date
    08-19-2011
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    4

    Excel Forumla needed to combine first letter of first name with last name in new column?

    In column E I have a list of 400 first names and in column F I have a list of their last names. How do I merge the first letter with the last name in another column. Column G is what I want in the below example.

    ExcelProb.pdf

  2. #2
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Excel Forumla needed to combine first letter of first name with last name in new colum

    There is nothing in column G in the example...

    But I believe what you are looking for is this:

    =CONCATENATE(LEFT(E1,1), F1)


    That will make this

    Jake Masters

    Look like this:

    JMasters

  3. #3
    Registered User
    Join Date
    08-19-2011
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Excel Forumla needed to combine first letter of first name with last name in new colum

    Yes that's what I want in column G. I have 400 names in both colums. How do I do the whole colum with all the names at once?

  4. #4
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Excel Forumla needed to combine first letter of first name with last name in new colum

    Amorous,

    Type/copy the formula that Jake has given you in post # 2 above, to Cell G1 in your workbook, then copy the formula down Column G as far as required.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1