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,