#1   Report Post  
Posted to microsoft.public.excel.misc
DEE DEE is offline
external usenet poster
 
Posts: 250
Default Merging Excel Cells

How do you merge data in multiple cells within an Excel Worksheet column
without losing data? (using Excel 2003)
  #2   Report Post  
Posted to microsoft.public.excel.misc
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)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Cells in Excel trib Excel Discussion (Misc queries) 1 July 28th 06 09:48 PM
excel cells are merging onto the next cell exhausted Excel Worksheet Functions 3 January 27th 06 11:50 AM
Merging cells in Excel 2003 Bob Excel Discussion (Misc queries) 1 October 19th 05 07:10 PM
Excel should have the option to merge contents when merging cells. Ceiling Tile 01 Excel Discussion (Misc queries) 2 August 31st 05 11:03 PM
merging cells excel 2003 tony Excel Discussion (Misc queries) 1 March 2nd 05 12:53 PM


All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"