Yes, there is a way to reverse the order of names from
Last, First to
First Last in Excel. Here are the steps:
- Select the column that contains the names you want to reverse.
- Click on the Data tab in the ribbon at the top of the screen.
- Click on the Text to Columns button in the Data Tools group.
- In the Convert Text to Columns Wizard window that appears, select Delimited and click Next.
- In the next window, make sure that only Comma is selected as the delimiter and click Next.
- In the next window, select the column that contains the first names and click Finish.
- Now you should have two columns, one with the last names and one with the first names.
- Insert a new column to the right of the first names column.
- In the first cell of the new column, enter the formula (assuming the last names are in column A and the first names are in column B).
- Drag the formula down to fill the rest of the cells in the new column.
- 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.