Excel – How to combine 2 cells into one

Do you have a column containing parts of a full name….that you’d prefer to have in a single cell?

It’s very simple to combine them with a simple Excel formulae.

Joining 2 cells

NOTE: It’s essential to include the double quote marks – and a space – to ensure the correct result.

If you need to do the reverse – split a cell into 2 or 3 (eg. for the first, middle and last name), see this article

 ~~~If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 

Posted on February 20, 2016, in Uncategorized and tagged , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: