Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Replacing spaces in text, with another character
I'm trying to replace spaces with plus signs. The following formula will do
it for the first space. How can I do this for all the spaces in the text string of cell F100? =REPLACE(F100,FIND(" ",F100),1,"+") Thanks, Paul |
#2
|
|||
|
|||
PCLIVE wrote...
I'm trying to replace spaces with plus signs. The following formula will do it for the first space. How can I do this for all the spaces in the text string of cell F100? =REPLACE(F100,FIND(" ",F100),1,"+") Use SUBSTITUTE instead of REPLACE. |
#3
|
|||
|
|||
Ah yes!
I knew I had seen it before. Thanks a bunch, Paul "Harlan Grove" wrote in message oups.com... PCLIVE wrote... I'm trying to replace spaces with plus signs. The following formula will do it for the first space. How can I do this for all the spaces in the text string of cell F100? =REPLACE(F100,FIND(" ",F100),1,"+") Use SUBSTITUTE instead of REPLACE. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove all spaces in a text string | Excel Discussion (Misc queries) | |||
Replacing #N/A with other text | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
removing text after a character | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |