Thread: Return while useing CONCATENATE
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Return while useing CONCATENATE
Or this:
=CONCATENATE(B3,CHAR(10),B4,CHAR(10),B5)
or
=B3&CHAR(10)&B4&CHAR(10)&B5



Gary''s Student wrote:

=CONCATENATE(B3 & CHAR(10), B4 & CHAR(10),B5)
--
Gary''s Student - gsnu200845

--

Dave Peterson
Reply With QuoteReply With Quote