Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default MERGING CELLS WITHOUT LOOSING DATA IN THE SECOND CELL

HOW TO MERGE TWO CELLS WITHOUT LOOSING THE CONTENTS OF THE SECOND ONE?IS IT
POSSIBLE ATLEAST?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default MERGING CELLS WITHOUT LOOSING DATA IN THE SECOND CELL

I would do it to addind one column, then concatenate cells, regarding what
for and how this information is used normally. Possibly I would then copy -
paste special - values depending use after.

Complicated I know but I don't know other way.

Why do you want to merge them?

"kalyan" kirjoitti:

HOW TO MERGE TWO CELLS WITHOUT LOOSING THE CONTENTS OF THE SECOND ONE?IS IT
POSSIBLE ATLEAST?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default MERGING CELLS WITHOUT LOOSING DATA IN THE SECOND CELL

Firstly, please get your Caps Lock key repaired and stop SHOUTING
Secondly, please don't merge cells, as merged cells cause many problems
(which you will see described in the archives of this group).
Thirdly, if you want to combine data, perhaps you want the CONCATENATE
function or the & operator?
--
David Biddulph

"kalyan" wrote in message
...
HOW TO MERGE TWO CELLS WITHOUT LOOSING THE CONTENTS OF THE SECOND ONE?IS
IT
POSSIBLE ATLEAST?



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 text and data fields without loosing zeroes ie .00l Bricap Excel Worksheet Functions 3 December 31st 07 03:26 AM
update cell without loosing previous data Susan Excel Discussion (Misc queries) 2 February 26th 07 05:00 AM
Merging Cells with Data In Them hellonpluto Excel Discussion (Misc queries) 3 May 11th 06 02:45 PM
how do I merge 2 cells in excel without loosing data wimmat Excel Discussion (Misc queries) 2 May 19th 05 10:50 AM
Add data to cell w/o loosing initial data jaycain Excel Discussion (Misc queries) 2 March 29th 05 02:23 AM


All times are GMT +1. The time now is 10:38 PM.

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"