| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell formatting with formula
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell formatting with formula
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell formatting with formula
=TEXT(H22,"000000000")&CHAR(10)&TEXT(J22,"00000000 0")
You will probably need to format the cell to wrap text. Format cells-Alignment-Check the Wrap Text. Regards, OssieMac "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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell formatting with formula
Use the formula:
=TEXT(H22,"000000000") & CHAR(10) & TEXT(J22,"000000000") Then select the cell that contains the formula Choose FormatCells On the Alignment tab, add a check mark to Wrap Text, and click OK 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Cell that Contains If/Then Formula | Excel Discussion (Misc queries) | |||
| In a formula, copy the value and formatting of another cell | Excel Worksheet Functions | |||
| cell formula or formatting | Excel Worksheet Functions | |||
| Formatting a formula within a cell | Excel Discussion (Misc queries) | |||
| Formatting a cell for color that has a formula also | Excel Discussion (Misc queries) | |||
Hybrid Mode
