I have a spreadsheet that is date by colume and customers by rows and I need
to concatenate the date and comment for each customer into one long string
for all dates and all comments per customer, an example is "09/01/08 review
10/01/08 left message 11/01/08 no answer". What I need to know is I would
like to copy this formula down which I can do but say the second customer
does not have a comment with 10/01/08 I would like their string to read
"09/01/08 left message 11/01/08 spoke to customer". Basically copying the
formula down but having it dynamically not concatenate if the comment field
is blank? Am I asking the impossible? Here is an example of my concantenate
statement.
=O$3&" "&O4&" "&P$3&" "&P4&" "&Q$3&" "&Q4

--
"If you can''''t have the best of everything make the best of everything you
have"...BIAKathy