Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Split 1st Name & Surname

  1. #1
    Join Date
    7th December 2006
    Posts
    2

    Split 1st Name & Surname

    Hi everyone,

    I don't know Excel very well and I've got a huge list of people's names, but their first and last names both occupy a single cell. I'd like to arrange the list to have one cell for their first names and another for their surnames - is there a quick way to get Excel to do that? The list is incredibly long and I'd love to get around doing this manually... is there a formula-based solution? I am using Office 2000.

    Thanks in advance!

    PS: I don't know what other detail to provide, if this is too vague, please let me know what else I can include.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,697

    Re: Single-cell Name & Surname Into 2 Cells

    Use Data>Text to Columns... Or


    =TRIM(LEFT(A1,FIND(" ",A1))) In B1
    and
    =TRIM(MID(A1,FIND(" ",A1),256)) in C1
    Copy down via Fill Handle

  3. #3
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Single-cell Name & Surname Into 2 Cells

    The formulas will give two new columns. Assuming the names start in cell A1, put this formula in cell B1 and fill down:

    =LEFT(A1,FIND(" ",A1)-1)

    and this in cell C1 and fill down:

    =RIGHT(A1,LEN(A1)-FIND(" ",A1))

    There are other ways to do this.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th December 2006
    Posts
    2

    Re: Split 1st Name & Surname

    Wow, you guys are amazing, that worked so well!! You have no idea how much time you have just saved me! THANK YOU!!!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Merge All Same 1st Names With 1 Surname
    By ahmd20 in forum EXCEL HELP
    Replies: 2
    Last Post: April 19th, 2008, 04:44
  2. Merge 1st Name Initial With Surname
    By vapor64 in forum EXCEL HELP
    Replies: 2
    Last Post: March 4th, 2008, 09:09
  3. Swap Multi Prefix Surname & First Name
    By Absa in forum EXCEL HELP
    Replies: 4
    Last Post: January 23rd, 2008, 14:13
  4. Split Full Name Into First & Surname
    By badger55 in forum EXCEL HELP
    Replies: 3
    Last Post: November 27th, 2006, 22:54
  5. firstname surname to surname firstname
    By mattoneill in forum EXCEL HELP
    Replies: 4
    Last Post: September 29th, 2004, 22:43

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
  •  
porno