How to combine first and last names

November 23, 2021
2.5K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

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.

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.

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