On Aug 28, 4:28 pm, fair_thumb
wrote:
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)