Mergin cells

Hello Jennifer,

Thank you for your question regarding combining data from two cells into one cell.

This is done using the function CONCATENATE. An example of this would be as follows:

=CONCATENATE(A2," ",B2) where A2 contains the first name and B2 contains the last name. The ," ", creates the space between the names.

After completing the above then select all cells with the formula, copy and paste values. This will remove the formula and clean up the data.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer