How to insert + sign in front of every word =Substitute(A3," "," +")

**inayet** · 03-16-2013, 06:26 PM

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

**dredwolf** · 03-16-2013, 06:31 PM

the easiest way I can think of is:
="+"&SUBSTITUTE(A3," "," +")
or
=SUBSTITUTE(" "&A3," "," +")

Hope this helps

**martindwilson** · 03-16-2013, 06:32 PM

=substitute(" "&a3," "," +")

**inayet** · 03-16-2013, 09:39 PM

Thank you martindwilson and dredwolf for your replies. I really appreciate it, this is great.

I tried the following function =substitute(" "&a3," "," +") to solve my problem and it worked.

**dredwolf** · 03-16-2013, 09:41 PM

Thank you for the feedback, glad that our solutions worked for you!

Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"