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.