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

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 FormatCellsAlignment tabCheck 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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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

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

"Max" wrote:

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 FormatCellsAlignment tabCheck 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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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

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


"Max" wrote:

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
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

Don't use merged cells. It causes a lot of pain.
I'm out of guesses/ideas here.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote in message
...
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