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

B

Bryan McHugh

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>
 
J

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

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

Ron Coderre

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
 
R

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
 
G

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
 
Top