cell formatting with formula

F

fair_thumb

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.
 
E

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.
Click to expand...

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

OssieMac

=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
 
D

Debra Dalgleish

Use the formula:

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

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