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.

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

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.

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.