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