Hi Forum Members
I am looking for some help with a formula. Basically I am looking for a formula that will remove portions of a string of data that is sometimes separated by commas which I want to keep. For example:



From this:
123FS+1day,345,333SS,567SF

To this:
123,345,333,567

Any help would be appreciated.

Here is an update since I posted:

I have two formulae that do what I want but separately, however what I need is for both formulae to run in the same cell at the same time. Here are the two formulae:

=REPLACE(H2,FIND("+",H2,1),FIND(",",H2,1)-FIND("+",H2,1),"")
and
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(H2,"S S",),H2,"FS"),H2,"SF"),H2,"FF")

Both work perfectly well independently but I want them both to work at the same time.

Many thanks in anticipation.

Tony