Thread: Putting text together from 3 cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Putting text together from 3 cells
in B2:

=A1&CHR(10)&A2

then copy down

or simply:

=A1&CHR(10)&A2&CHR(10)&A3
Reply With QuoteReply With Quote