View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Godinger David Godinger is offline
external usenet poster
 
Posts: 22
Default Formula for Replacing Text in a String?

I'd like to make a formula (NOT USING VBA) that would replace, in a list of
characters, all instances of the following with nothing:

, ,


(That's a comma followed by a space, followed by a comma, followed by a
space.)

If possible, the formula would also eliminate the last character in the
string if it's a comma.

Thanks,

Dave

--
Please delete "ANTI-SPAM" from email address
David Godinger: Go player, student of Mahatma Gandhi, the Buddha, and Dr. Martin King