The result of a formula I'm using gives both text and numerical data but I
want to split the results so that it wraps to a new line at a set point eg.
M=23
V=52
on different lines within the cell (as if you were using <Alt<Enter

With
A1: 23
A2: 52

Try something like this:

A3: ="M="&A1&CHAR(10)"V="&A2

That formula returns:
M=23
V=52

Remember to set the cell format to Wrap Text

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Bryan McHugh" wrote:

The result of a formula I'm using gives both text and numerical data but I
want to split the results so that it wraps to a new line at a set point eg.
M=23
V=52
on different lines within the cell (as if you were using <Alt<Enter

On Mar 7, 4:36 pm, Bryan McHugh <Bryan
wrote:
The result of a formula I'm using gives both text and numerical data but I
want to split the results so that it wraps to a new line at a set point eg.
M=23
V=52
on different lines within the cell (as if you were using <Alt<Enter

Something like this might meet your needs:

="M=" & M1 & char(10) & "V=" & V1

Note: You might also need to set Wrap Text using Format - Cells -
Alignment. It's a good idea anyway because Excel seems to "forget" to
autowrap text sometimes.

=SUM(A1:A2)&CHAR(10)&"test"
and format for WrapText

Vaya con Dios,
Chuck, CABGx3



"Bryan McHugh" <Bryan wrote in message
...
The result of a formula I'm using gives both text and numerical data but I
want to split the results so that it wraps to a new line at a set point
eg.
M=23
V=52
on different lines within the cell (as if you were using <Alt<Enter

Format A1 to "Wrap Text", then,
With G1 to G4 containing 10, 13, 26, 26 respectively,
try this in A1:

="M="&G1+G2&CHAR(10)&"V="&G3+G4

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bryan McHugh" <Bryan wrote in message
...
The result of a formula I'm using gives both text and numerical data but I
want to split the results so that it wraps to a new line at a set point
eg.
M=23
V=52
on different lines within the cell (as if you were using <Alt<Enter

Bryan

=M1&CHAR(10)&V1

Set the cell format as "Wrap Text"

Note M and V are not cell addresses so I just used M1 and V1


Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 16:36:10 -0800, Bryan McHugh <Bryan
wrote:

The result of a formula I'm using gives both text and numerical data but I
want to split the results so that it wraps to a new line at a set point eg.
M=23
V=52
on different lines within the cell (as if you were using <Alt<Enter