I'm trying to extract three different types of invoice numbers...
1st Appears with three letters LBC,LPA,SAA etc followed by five numbers then a back slash then two more numbers e.g. 12540/01
2nd Appears with 10 digits starting with 2000 e.g. 2000685684
3rd Appears with 10 digits starting with 1800 e.g. 1800140735

I'll probably need three separate formulas, however if I could combine the three that would be prefect...

Any ideas??

Quote Originally Posted by Excel Fox View Post
The text strings you want to extract have different arrangement of numeric and text characters. The first bit uses 3 text characters 5 numerics, a back slash and 2 numerics.

The others have 10 numerics. So what's the logic?