Hello,

I hope that you are doing well, and thank you for viewing my question. I hope that you can assist with this question.


DESCRIPTION OF PROBLEM

Right now I am using the formula =Substitute(A3," "," +") to insert a + sign in front of every word. This formula is great, but there is one thing that it does not do so well, this formula does not insert the + sign in front of the first word.

So for example if there is a phrase like THIS FORUM IS AWESOME using the above formula will give you this result THIS +FORUM +IS +AWESOME

SOLUTION BEING SOUGHT

I would like to know what formula/function I can use so that every word including the first word in a phrase has the + sign .

Thank you for your help!

Sincerely,
Inayet