Using the Concatenate function in Excel

B

BIAKathy

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
 
A

Al Campagna

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."
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top