Thread: Formula Help Request
View Single Post
 
Old 02-21-2013, 08:38 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
Quote:
Originally Posted by macropod View Post
Hi Tony,

Since you can have + or - and a variable string from there till the first comma, try:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(H2,MID(H2,IF(ISE RROR(SEARCH("+",H2)),SEARCH("-",H2),SEARCH("+",H2)),SEARCH(",",H2)-IF(ISERROR(SEARCH("+",H2)),SEARCH("-",H2),SEARCH("+",H2))),""),"F",""),"S","")
(delete unwanted spaces inserted by the board software)
Hi Paul
That worked perfectly.
Many thanks for your help.
Tony
Reply With Quote