Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Last Name, First Name function in Excel (Excel 2002, 2003)

    Is there a function I can use to separate "Smith, John" that appears in COL A which will put Smith in COL A and John in COL B. Separate the names where the comma is? Thank You

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Last Name, First Name function in Excel (Excel 2002, 2003)

    Select a column of such data, then select Data | Text to Column...
    Specify Delimited, then in the next step specify comma as separator.

Posting Permissions

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