View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yovation yovation is offline
external usenet poster
 
Posts: 18
Default Concatenate question

I tried posting this yesterday but haven't seen it.

I am using this formula to concatenate.

=(A1&", "&B1&", "&C1&", "&D1&", "&E1&", "&F1&", "&G1&", "&H1)

Some of the cells are blank. How can I change the formula so the
double commas ', , ' won't show.

Thank you.
David