How do I reverse name order from Last, First to First Last in Exc
 

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 an Excel spreadsheet?

Answer: How do I reverse name order from Last, First to First Last in Exc
 

Yes, there is a way to reverse the order of names from Last, First to First Last in Excel. Here are the steps:

1. Select the column that contains the names you want to reverse.
2. Click on the Data tab in the ribbon at the top of the screen.
3. Click on the Text to Columns button in the Data Tools group.
4. In the Convert Text to Columns Wizard window that appears, select Delimited and click Next.
5. In the next window, make sure that only Comma is selected as the delimiter and click Next.
6. In the next window, select the column that contains the first names and click Finish.
7. Now you should have two columns, one with the last names and one with the first names.
8. Insert a new column to the right of the first names column.
9. In the first cell of the new column, enter the formula
   Formula:

   ---

   =B1&" "&A1 


   ---

   (assuming the last names are in column A and the first names are in column B).
10. Drag the formula down to fill the rest of the cells in the new column.
11. Now you should have a column with the names in the format First Last.

That's it! You can now use the new column with the reversed names to print your mailing labels.

How do I reverse name order from Last, First to First Last in Exc
 

=MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1))
--
Gary's Student


"Annie Lord" wrote:

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 an Excel spreadsheet?

How do I reverse name order from Last, First to First Last in
 

Thank you so much!! That saves me enormous amounts of time. A

"Gary''s Student" wrote:

=MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1))
--
Gary's Student


"Annie Lord" wrote:

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 an Excel spreadsheet?

How do I reverse name order from Last, First to First Last in
 

You are very welcome.
--
Gary''s Student


"Annie Lord" wrote:

Thank you so much!! That saves me enormous amounts of time. A

"Gary''s Student" wrote:

=MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1))
--
Gary's Student


"Annie Lord" wrote:

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 an Excel spreadsheet?