LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Merge the contents of multiple cells into one cell

I've merged contents of multiple cells into one and now that I don't need A2
and B2 Cells, the information from the merge disappears if i delete those two
cells. How do I stop this?

Example below:

A2: 869000471
B2: 02810
C2: 86900047102810

The formula that I used was =A2&""&B2


 
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
separate contents of one cell into multiple cells Horacio[_4_] Excel Worksheet Functions 4 January 24th 10 12:25 AM
Excel 2000 - Split Contents of Cell Across Multiple Cells DeeW Excel Discussion (Misc queries) 7 November 8th 06 09:10 PM
copy contents of multiple cells into a new cell - Help Needed Please [email protected] Excel Programming 1 July 28th 06 04:04 PM
How do I merge 2 cells to 1 when contents are numbers traceyclarity Excel Discussion (Misc queries) 3 January 27th 06 03:54 PM
How do I combine the contents of multiple cells in one cell? Debbie Excel Worksheet Functions 3 December 16th 05 10:57 PM


All times are GMT +1. The time now is 03:32 PM.

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

About Us

"It's about Microsoft Excel"