Ashley Cameron Design

Ashley Cameron Design

Shop the Creative Design Market

Good evening

Combine First & Last Name ( 2 Columns into 1 Cell) Using Excel

ExcelTutorials

About a 1 minute read

"There is one thing one has to have: either a soul that is cheerful by nature, or a soul made cheerful by work, love, art, and knowledge."

Friedrich Nietzsche

Let’s look at a simple formula to help you combine 2 columns of data into 1 cell, such as combining a first and last name, in Excel.

For example, to combine cells A2 and B2 the formula would be:

=A2&” “&B2

This adds a space between the names. You can include any character between the quotation marks.

I hope this video helps. If it did, please Like the video to save it and so others can find it and Subscribe for more content like this. Let me know in the video comments if it helped and if you have any other suggestions for content.

💸TIPS — You’re never required to leave a tip! If you feel called to, you can use either of the options below. [Thank you!]

Venmo: https://tr.ee/i-8jQchi4N
PayPal: https://tr.ee/Ktw6gMU8iX