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.