Formula Help Request
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
Last edited by OTPM; 02-19-2013 at 11:21 AM.
|