Prev: Creating a form in Excel
Next: Conditional Formating based on Date
From: Syed Wahaj Ul Hasan Syed Wahaj Ul on 7 Mar 2010 10:52
wow! many thanks... it worked perfectly fine and solved my problem. Best
Regards, Wahaj

"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.
From: Joe on 3 Apr 2010 14:19
Are there any characters that can be added between the &" and the "& so that
the combined cells can appear as a list instead of a line? For instance, I
have two sentences in two different cells. I want to put in one cell, but
have one above the other with spacing in between.

"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.
From: Paul on 3 Apr 2010 15:59

You can use:

=A1&CHAR(10)&B1

Be sure to format the cell as having wrapped text, otherwise you'll
just see a small symbol between the values from A1 and B1.


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192711

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Creating a form in Excel
Next: Conditional Formating based on Date