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?
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?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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??
Originally Posted by Excel Fox
Posting Permissions
Reply With Quote
Bookmarks