Thread: add a new line on the same cell using a formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default add a new line on the same cell using a formula
You use =char(10) in a cell on the worksheet.

chr(10) is for VBA.

=A1&Char(10)&A2&Char(10)&A3

"karlo <" wrote:

hmmm... i already tried Chr(10) even before but it doesnt seem to work.
Im using Excel 2000. would that be a problem?

Are there other workarounds?

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

Reply With QuoteReply With Quote