Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How to combine cell contents in Excel

No comments
11:42 AM - Just came back from e-Payment meeting, when Mr. Jonathan (the congressman) approach my desk to ask something.

The Congressman

Bro. Can you please take a look on my excel spreadsheet?


foxtrot

OK sir. No problem.


The Congressman

How can I combine cell contents here in excel?


To combine cell contents from different columns in excel, use this formula:

=A1 & " " & B1 & " " & C1

Where A1, B1, C1 are the cells you want to concatenate. The ampersand character (&) tells Excel to "add" text together to create a new text value.

No comments :

Post a Comment