Using the Concatenate function in Excel

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

BIAKathy,
This doesn't appear to be a Microsoft Access question.
This newsgroup deals with Microsoft Access, a relational database
application.
You'll have better luck posting this question on an Excel newsgroup like
microsoft.public.excel.programming
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"BIAKathy" wrote in message
...
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

Thank you, I am new to this site and was on the wrong selection, I have
re-posted my question on the Excel Discussion board
--
"If you can''''t have the best of everything make the best of everything you
have"...BIAKathy


"BIAKathy" wrote:

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