View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MRHenn MRHenn is offline
external usenet poster
 
Posts: 1
Default EXCEL 2003: how to add CR or alt-enter using CONCATINATE function

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.