Remove extra comma in a text fild

[smartcard]

My sheet's colunm B has text with some extra comma's. I want to know how to remove them?

What I have:

Please Login or Register  to view this content.

What result I want:

Please Login or Register  to view this content.

[sweep]

Hi,

This might do the job for you.

=SUBSTITUTE(TRIM(SUBSTITUTE(B1,","," "))," ",",")

[martindwilson]

in col c put
=TRIM(SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(B1," ","^"),","," "))," ",","),"^"," ")) fill down
then copy paste back special values
the above formula retains existing spaces
eg
,,,,,,Apple,,Orange box ,,, becomes
Apple,Orange box