Thread: EXCEL 2003: how to add CR or alt-enter using CONCATINATE function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default EXCEL 2003: how to add CR or alt-enter using CONCATINATE function
char(10)

=concatenate(a1,"-",b1,char(10))
or
=a1&"-"&b1&char(10)



MRHenn wrote:

i am trying to insert a carriage return or alt-enter in a cell in the
CONCATINATE function. CONCATINATE(a1, "-", b1, "(enter)") where enter is
the symbol i need to use. do not know what it is so it will force an CR or
alt-enter.

--

Dave Peterson
Reply With QuoteReply With Quote