View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Merging Excel Cells

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!*


"Dee" wrote:

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