cell formatting with formula

[Guest]

Hello members,

my formula in A1 is
=TEXT(H22,"000000000")
&TEXT(J22,"000000000")

How can I force a *display* in A1 *to be* in two lines <one for each of my
*text sub-formula*>

thanks in advance for any suggestions.

 

[Edmonton]

Hello members,

my formula in A1 is
=TEXT(H22,"000000000")
&TEXT(J22,"000000000")

How can I force a *display* in A1 *to be* in two lines <one for each of my
*text sub-formula*>

thanks in advance for any suggestions.

The function "Concatnate" should work:
=Concatnate(H22,"000000000","enter the text",J22,"00000000)

 

[Guest]

=TEXT(H22,"000000000")&CHAR(10)&TEXT(J22,"000000000")

You will probably need to format the cell to wrap text. Format
cells->Alignment->Check the Wrap Text.

Regards,

OssieMac

 

[Debra Dalgleish]

Use the formula:

=TEXT(H22,"000000000") & CHAR(10) & TEXT(J22,"000000000")

Then select the cell that contains the formula
Choose Format>Cells