View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default can you wrap formula results via a formula eg. Alt Enter

=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