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
|