View Single Post
  #41   Report Post  
Old May 10th 10, 06:52 PM posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1,522
Default How do I merge two cells without deleting data from the cell?

When all else fails, think about it....

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stephie" wrote in message
...
This worked perfectly, however, I now need to put a comma between the two
names - i.e. currently I have Smith John in one cell, and need Smith, John
in
one cell. Is there a way to do that?

"Peo Sjoblom" wrote:

You can't, you can concatenate 2 cells into one by using a formula and
ampersand

=A1&" "&B1


however stay away from merging cells, always cause more problems than
what
it's worth and layout wise you can get very close without using it. I
have
never seen a power user using merging

Regards,

Peo Sjoblom

"Batmans_Wife" wrote:

I'm highlighting two cells in the same row, hitting format cells,
alignment,
merge cells and I'm getting the error message, "The selection contains
multiple data values. Merging into one cell will keep the upper-left
most
data only." I want to be able to make the two seperate cells one
without
deleting anything and without having to cut and paste.