Sure, I can help you with that! You can use the
function in Excel to add a comma between the last name and first name. Here are the steps:
- Select the cell where you have the last name and first name together.
- In the formula bar, type
Formula:
=CONCATENATE(A1,", ",B1)
where A1 is the cell with the last name and B1 is the cell with the first name. - Press Enter and you will see the last name and first name separated by a comma in the same cell.
Alternatively, you can use the ampersand (&) symbol instead of the
function. Here's how:
- Select the cell where you have the last name and first name together.
- In the formula bar, type where A1 is the cell with the last name and B1 is the cell with the first name.
- Press Enter and you will see the last name and first name separated by a comma in the same cell.