How to combine first and last names

November 23, 2021
87 Views 0

Graphic skills

How can we merge different cells while keeping all contents inside? Follow these few steps.

Suppose that we need to combine the contents in cell B3 and C3.

1. Enter =A3&B3 in cell D3.

2. Then youll find the the first and last name combined in cell D3.

how to combine first and last name in excel (1).gif 

 

However, we know that there should be a space between each first and last name. Can we realize it?

1. Enter =A3& &B3 in cell D3. (Note that there should be a space within the pair of quotation marks, regarding the language habits of English users.)

2. Then youll get the expected result.

how to combine first and last name in excel (2).gif 

 

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.