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
|