View Single Post
 
Old 02-19-2013, 06:30 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default 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.
Reply With Quote