Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change order of information in cells(excel 98) (windows 98)

    Hello.
    I have a worksheet that has a list of names. The names were entered (first name, last name) in the same column. I need to change this list to (last name, first name). For example, Jerry Hernandez = Hernandez, Jerry. Is there a formula that I can used to change this information, without having to retype the list?

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

    Re: Change order of information in cells(excel 98) (windows 98)

    Welcome to Woody's Lounge!

    What exactly is the current format of the names? You state "first name, last name", but your example is "Jerry Hernandez" (no comma).
    Let's say your list is in column A starting in A1. Enter the following formula in B1, then fill down as far as necessary.
    If the format is "firstname, lastname":
    <code>
    =MID(A1,FIND(", ",A1)+2,1000)&", "&LEFT(A1,FIND(", ",A1)-1)
    </code>
    If the format is "firstname lastname":
    <code>
    =MID(A1,FIND(" ",A1)+1,1000)&", "&LEFT(A1,FIND(" ",A1)-1)
    </code>
    The formulas won't handle double names such as Mary Ann Evans correctly.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Change order of information in cells(excel 98) (windows 98)

    If you are going thru to trouble of doing this, I suggest parsing into 2 separate columns. Then you can arrange them anyway you want much more easily.

    Steve

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Change order of information in cells(excel 98) (windows 98)

    Also, see MVP Chuck Pearson's Extracting First And Last Names
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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