1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Dividing First and Last Names in Excel

Discussion in 'Business Applications' started by dfriend846, Jan 25, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. dfriend846

    dfriend846 Thread Starter

    Joined:
    Aug 11, 2005
    Messages:
    208
    I have an Excel file of names (like John Smith) where the first and last name are entered in a single cell. Unforturnately, the names should have been entered in two cells - one for first name and one for last name. Can anyone think of a way to break the data apart perhaps by detecting the space between the names and putting the characters before it in one column and the characters after it in another?

    Thanks,

    Dennis
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Hello Dennis, use the Main Menu Data>Text to Columns function.
     
  3. debjitmandal

    debjitmandal

    Joined:
    Jan 1, 2007
    Messages:
    16
    thanks OBP for the solution.
    but i think it will not solve the purpose of the defriend846
    if first name is too long then what will happen?????????
     
  4. debjitmandal

    debjitmandal

    Joined:
    Jan 1, 2007
    Messages:
    16
    thanks OBP for the solution.
    but i think it will not solve the purpose of the defriend846
    if first name is too long then what will happen?????????(n)
     
  5. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    76,921
    use the text delimiter option and use <space> as the delimiter.
     
  6. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Thank you valis. :D
     
  7. debjitmandal

    debjitmandal

    Joined:
    Jan 1, 2007
    Messages:
    16
    valis right solution
     
  8. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    76,921
    de nada. there's my solution for the year, and it's still January! w00t indeed. :)

    if it meets your needs, don't forget to mark it solved under thread tools at the upper right.
     
  9. dfriend846

    dfriend846 Thread Starter

    Joined:
    Aug 11, 2005
    Messages:
    208
    thank you all very much.

    dennis
     
  10. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/538273

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice