How to combine first and last names

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 you’ll find the the first and last name combined in cell D3.

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 you’ll get the expected result.

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