| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Threaded Mode
