Results 1 to 4 of 4

Thread: Need help to reverse the name order in Microsoft Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    61

    Need help to reverse the name order in Microsoft Excel

    I received a file from an outside vendor with names listed Last, First. I need to print labels for mailing from this file with names First, Last. Is there a way to reverse the order in the Excel spreadsheet.

  2. #2
    Join Date
    Aug 2011
    Posts
    695

    Re: Need help to reverse the name order in Microsoft Excel

    There is a small formula that can help you. Try the following : =MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1)).

  3. #3
    Join Date
    Aug 2011
    Posts
    566

    Re: Need help to reverse the name order in Microsoft Excel

    I have got a tips that can be very helpful for you. In this formula it is possible to reverse a Last Name with First name and so on. Before that you will need to first understand how it works. The formula consist of functions like LEN, FIND, MID, LEFT, RIGHT. Under this LEN is responsible of returning number of characters in value. FIND will return the position of value with other. MID will extract the value to be reversed. LEFT will check the left value and RIGHT might shift it. So the formula is =FIND(" ",B3,1). With this you can find the space and then use =LEFT(B3,FIND(" ",B3,1)) for last name and =RIGHT(B3,LEN(B3)-FIND(" ",B3,1)) for first name.

  4. #4
    Join Date
    Jul 2011
    Posts
    623

    Re: Need help to reverse the name order in Microsoft Excel

    Here is a much easier example for you. The formula to do this is ==E27&" "&D27. Where E27 is the cell which has Last Name and D27 is the cell which has First Name. In the third cell type the formula and hit enter. Remember that if you put a comma after E27&" then the comma will also appear in the name. In that place you can use a separator. To reverse it just reverse the cell order.

Similar Threads

  1. It is possible to get reverse text Microsoft Excel
    By Indudep in forum MS Office Support
    Replies: 4
    Last Post: 25-01-2012, 06:17 PM
  2. Replies: 2
    Last Post: 21-01-2012, 04:51 PM
  3. Replies: 1
    Last Post: 14-01-2012, 06:51 PM
  4. How to Reverse Row Order in Microsoft Excel
    By Raju Chacha in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 06:25 PM
  5. How can I reverse the order of text on a Excel cell
    By Sunny55 in forum Windows Software
    Replies: 3
    Last Post: 06-06-2009, 09:50 PM

Tags for this Thread

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
  •  
Page generated in 1,711,659,953.89124 seconds with 16 queries