View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blustripes blustripes is offline
external usenet poster
 
Posts: 1
Default How do I insert a line break using a formula (e.g when concatenat.

I'm concatenating values from multiple cells into a single cell and want to
put a line break in between them so as instead of getting e.g.
Mary,Tom, Ted
they appear as follows within a single cell:
Mary
Tom
Ted

I know I can do this manually using CTRL+carriage return but how can I do it
within my formula?