Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: Newbe - Help with name order in fields

    I have a data base of 8000 names in Excel that are listed in one field as SMITH, JOE. I need to reverse the names and possibly seperate them into two fields. They also need to appear in proper case. (Joe Smith) Any ideas?

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Quote Originally Posted by JenK
    I have a data base of 8000 names in Excel that are listed in one field as SMITH, JOE. I need to reverse the names and possibly seperate them into two fields. They also need to appear in proper case. (Joe Smith) Any ideas?

    Perhaps the easiest way is to use Data > Text to Columns

    If that doesn't work, there are some formulas that can help.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Text to columns to split on a delimeter such as your Comma,

    Or a couple of formulas to do this in one
    to get First Name
    =PROPER(TRIM(RIGHT(A1,LEN(A1)-FIND(",",A1))))
    to get last name
    =PROPER(TRIM(LEFT(A1,FIND(",",A1)-1)))

    but this will only work for the data in the above format and without any errors
    post back if you have any more questions

Posting Permissions

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