Merging Excel Cells

[Dee]

How do you merge data in multiple cells within an Excel Worksheet column
without losing data? (using Excel 2003)

 

[Luke M]

You can string text from multiple cells together by using the ampersand.

=A1&A2&A3

Joins all the data from those 3 cells into 1.

 

[Sri]

You can string text from multiple cells together by using the ampersand.

=A1&A2&A3

Joins all the data from those 3 cells into 1.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Hi Dee,
Check the below articles to get a good insight about merge.
http://funwithexcel.blogspot.com/2009/04/macro-to-merge-column-or-row-or-range.html
http://funwithexcel.blogspot.com/2009/04/merge-two-cells-with-new-line-in.html
http://funwithexcel.blogspot.com/2009/04/difference-between-merge-and-sum-in.html