How to copy a formula to multiple cells without filling blanks cells too..

[leftbehind321]

Hi,

I'm attempting to use a concatenate formula on a list of keywords, however some of the keywords are blank. Is there any way I can get my concatenate keyword to not appear in these fields.

I'm attempting to insert a '+' symbol before every keyword but I have 8000+ keywords.

E.G.

Keyword Concatenate
example1 +example1
example2 +example2
+
example 3 +example3

I'm attempting to find a way to drag the formula down without inserting the '+' into cells where there are no keywords.

Kind Regards,

[mahju]

Hi

I am not sure what exactly you want but try this
if date is in column 'C" & 'D' then
It will add a plus sign if any of these cells are not blanl

Please Login or Register  to view this content.

Upload a sample sheet if it is not requied
Regards