Thanks xor, that is great.
I am not familiar with those functions so could never have got there. It took me hours of fumbling before joining this forum and posting the problem. So I am impressed with the speed of your response.

At the risk of being cheeky - is there a way of making the formula remove the 's' prefix on the job number at 'A8' rather than manually removing it?
I say this because the data table is populated from a query run separately for different customers, so the data will change frequently and the 's' prefixes are a common factor that will crop up often.
This extra part of the solution would make it perfect.

Regards,
garymon