Extract cell text string between 2 different characters

Hi Everyone,

I need some help with the following data column where i have a list of supplier codes and names that need to have just the number element extracted without any preceding zeros, however, gets a bit more tricky as i don't know the number of preceding zeros for each vendor code as per example below;

000000213908 - ACme data systems
0009065 - BB4 enterprise9
0000000012309 - Evans ltd

Values that should be returned are 213908, 9065 and 12309 respectively.

The position of the dash after the number is always in the same place.

Any formula ideas that would help?

Thanks

Shallabee.

This might do the trick...

Formula:

Please Login or Register  to view this content.

the position of the dash after the number is always in the same place.

Formula:

Please Login or Register  to view this content.

Originally Posted by PaulSP8

This might do the trick...

Formula:

Please Login or Register  to view this content.

Thanks, this partly works but includes the Supplier name that should be removed so only 3965 remains.

3965 - ABC 123 Ltd

Originally Posted by XLent

Formula:

Please Login or Register  to view this content.

Excellent, many thanks, just what i needed.