Thread: char(10) does not work to form a new line in my formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default char(10) does not work to form a new line in my formula
You have to format the cell to wrap text.

A1:A3 = merged cells

Entered this formula:

="Line1"&CHAR(10)&"Line2"&CHAR(10)&"Line3"

Goto the menu FormatCellsAlignment tabWrap TextOK

The result of the formula appears as:

Line1
Line2
Line3

You may have to adjust the row height to get the exact fit you want.

--
Biff
Microsoft Excel MVP


"Sandy" wrote in message
...
i am merging a few cells into one, but want them to appear on 3 separate
lines. char(10) does not seem to be working.


Reply With QuoteReply With Quote