Hi,

I'm looking for a formula which helps me to extract text from a text string.

ie:

GBGD.6251.700001.netpay
GBGD.6251.700001.paye
GBGD.6251.700001.NI
GBGD.6251.700008.pension contribution
GBGD.6251.700020.EER
GBGD.6251.700021.EEE
And I'd like to extract only 700001,700008,700020& 700021.
I've looked at MID,LEN ect but not sure how i can use those formula for this purpose.

Can someone help me?
I also attached the Excel example.

Many thanks

Attached Files

Book1.xlsx (8.7 KB, 12 views)