I want to replace spaces in a string with a plus sign. Can somebody tell me how to do that?
Before: South America
After: South+America
I want to replace spaces in a string with a plus sign. Can somebody tell me how to do that?
Before: South America
After: South+America
Try
=SUBSTITUTE(A1," ","+")
If your text is in cell A1.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Have you tried Find + Replace
What = " " space
Replace = +
I found a way to do it.
Thanks for your help.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks