View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MH MH is offline
external usenet poster
 
Posts: 28
Default Combine text from multiple cells into one cell - =(A1&","&A2","&A3

I would like to combine the words from different cells into one cell -
sometimes 1 or 2 cells are left empty

Example
A1 A2 A3 A4 A5
Peter Simon Derek Empty Kent

combine into one cell marking all
=A1&","&A2&","&A3&","&A4&","&A5

Should say
Peter, Simon, Derek, Kent (without extra , or space for empty cell included)

Could somebody help me with formula for this? would be greatly appreciated