S
Smonsmo7
I would like to combine text from multiple cells inserting a comma between each word and the word "and" before the last cell combined, followed by a period.
NO problem you say, Just use the concatentate function. Here's the problem.
Cells A1:A15 are cells that when checked will add a new word to the sentence.
For instance, I put an X in A1, this adds the word found in cell B1 to my growing sentence. This should continue thru each cell in column A1:A15.
There could be as little as one cell chosen inwhich case no "and" should be added but should be followed by a period.
Thanks for the help.
NO problem you say, Just use the concatentate function. Here's the problem.
Cells A1:A15 are cells that when checked will add a new word to the sentence.
For instance, I put an X in A1, this adds the word found in cell B1 to my growing sentence. This should continue thru each cell in column A1:A15.
There could be as little as one cell chosen inwhich case no "and" should be added but should be followed by a period.
Thanks for the help.