Trim and Merge cells in Excel

Hi Michael,

You can use the CONCATENATE function or the & operator to merge the first name and second name into one cell. Here’s how you can do it:

=CONCATENATE(A2, " ", B2)

or

=A2 & " " & B2

In these formulas, A2 represents the cell with the first name and B2 represents the cell with the second name. The " " in the middle is a space character, so there is a space between the first and second names in the result.

You can enter this formula in the first row where you want the full name to appear, and then drag the fill handle (the small square at the bottom-right of the cell) down to copy this formula for all the other rows.

Please replace A2 and B2 with the actual cell references for your first name and second name columns. If you have a header row, you might start with A2 and B2, but if you don’t, you might start with A1 and B1.

Remember to save your changes before you proceed with sending out your bulk emails.



Kind regards

Richard


STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector