can you wrap formula results via a formula eg. Alt Enter

[Guest]

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>

 

[joeu2004]

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.

 

[Guest]

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

 

[Ragdyer]

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

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