View Single Post
  #43   Report Post  
Old May 27th 10, 09:46 PM posted to microsoft.public.excel.misc
Jess12 Jess12 is offline
external usenet poster
First recorded activity by ExcelBanter: May 2010
Posts: 1
Default How do I merge two cells without deleting data from the cell?

That works except now i have a lot of spaces between the information. How
would you get rid of those spaces

"Peo Sjoblom" wrote:

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

=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


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.