|
Posted to microsoft.public.excel.misc
|
|
|
Concatenating cells but excluding blanks
Try this:
http://img690.imageshack.us/img690/5826/nonamee.png
Micky
"Bob Freeman" wrote:
Hello,
I am trying to create a result field, concatenating populated cells from the
previous 12 columns on that line, but excluding blank cells and putting a *
delimiting character between each instance - please find below a 4 column
example.
ID 1 2 3 4 Result
Z A C D A*C*D
Y B C B*C
X A B D A*B*D
Each of the 10,000 lines of the spreadsheet is different - there are at
least 5 blank cells on each line
Any help gratefully received. I am working in Excel 2007
Many thanks.
Bob
|