View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Concatenation and skipping blank cells

On Mon, 29 May 2006 14:43:02 -0500, Dave Peterson
wrote:

Are all the values in A1:F1 single words--no spaces?

If yes:

=SUBSTITUTE(TRIM(A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1)," ",", ")



Neat solution for single word entries!


--ron