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
Bookmarks