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
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
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.
Ah yes!
I knew I had seen it before.
Thanks a bunch,
Paul
"Harlan Grove" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks