How to type text in combined cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 27 Mar 2008 04:58 GMT

Does anyone have any suggestions on how to type text in combined cell?
For example, when I join A1 and A2 cells together, and enter a formula
If true, then type the text A at top and M at bottom, which looks like
following
A
M
in combined cell A1 and A1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Reply to this Message

Max - 27 Mar 2008 07:18 GMT

Presume you meant something like this?

If A1 contains: A, A2 contains: M,
A3 to return it as:
A
M

If so, first, format A3 to wrap text,
via Format>Cells>Alignment tab>Check Wrap Text

Then place in A3: =A1&CHAR(10)&A2

If you meant just how to break for a new line in a cell when entering data
manually, just press Alt+ENTER where you want to break it.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Does anyone have any suggestions on how to type text in combined cell?
> For example, when I join A1 and A2 cells together, and enter a formula
[quoted text clipped - 6 lines]
> Thanks in advance for any suggestions
> Eric

Reply to this Message

Eric - 27 Mar 2008 07:34 GMT

I don't mean type it manually, I need to set a cell formula , if the
condition is true then return
A
M
else "".
Do you have any suggestions?
Thank you very much for any suggestions
Eric

> Presume you meant something like this?
>
[quoted text clipped - 20 lines]
> > Thanks in advance for any suggestions
> > Eric

Reply to this Message

Max - 27 Mar 2008 08:01 GMT

> I don't mean type it manually, ..

Ok, but I did give you 2 options earlier,
and with the formula option explained ahead??

One last go here,
with A3 pre-formatted to wrap text (this formatting is required)

Try something like this in A3:
=IF(COUNTA(A1:A2)=2,A1&CHAR(10)&A2,"")
where A1:A2 will contain the text to be combined: A, M

Or, perhaps something like this in A3:
=IF(COUNTA(A1:A2)=2,"A"&CHAR(10)&"M","")
which will give the desired "fixed" text return:
A
M
if the condition checked is TRUE, else "" (as you stipulated)

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I don't mean type it manually, I need to set a cell formula , if the
> condition is true then return
[quoted text clipped - 4 lines]
> Thank you very much for any suggestions
> Eric

Reply to this Message

Eric - 27 Mar 2008 17:08 GMT

Thank you for your reply
I would like to return both chars in combined cell A1 & A2
If this is true, then return A in cell A1 and M in cell A2, but A1 and A2
are combined cell, which show as below
A
M
Do you have any suggestion?
Thank you very much for any suggestion
Eric

> > I don't mean type it manually, ..
> Ok, but I did give you 2 options earlier,
[quoted text clipped - 21 lines]
> > Thank you very much for any suggestions
> > Eric

Reply to this Message

Max - 27 Mar 2008 23:57 GMT

Don't use merged cells. It causes a lot of pain.
I'm out of guesses/ideas here.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thank you for your reply
> I would like to return both chars in combined cell A1 & A2
[quoted text clipped - 5 lines]
> Thank you very much for any suggestion
> Eric

Reply to this Message