Combine different cells value in excel

Posted: Wednesday, 30 November 2011 in Microsoft Office
Tags: , , , , , ,

Some people sometimes want to combine data from several different cells in Microsoft Excel, here’s how to combine multiple data in different cells.

To combine data, you can use “&” code (without “)

Excample, Use this function to combine

=Cell1&Cell2&Cell3

if you want to add space between data, use ” ” like this

=Cell1&” “&Cell2&” “&Cell3

Click Here for the example workbook.
or
http://dl.dropbox.com/u/40405769/Blog/Combine.xls

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s