If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Using the Concatenate function in Excel
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 |
#3
|
|||
|
|||
Using the Concatenate function in Excel
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 |
Thread Tools | |
Display Modes | |
|
|