Hi Tony,



Perhaps: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(H2,"+1day","")," F",""),"S","")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul
Many thanks for the response.
The +1day may be +10days or +3wks. So I need a formula that will find the location of a "+" or "-" sign and remove everything from there up to either a comma (but retain the comma) or the end of the string.
There will also be -10days or -3wks but I can work that out when I get the formula to work for the "+" options.
Kind regards
Tony