So the example would be TT-0007A
I know how to extract the 0007 but then I think I want to convert it to an integer so I can then do some logic that says if this four digit number is equal to or greater than 0200 but equal to or less than 299 THEN....
(by the way what would be the Syntax for equal to or greater than? equal to or less than?)
The Val function would ignore the 000 and give just 7 I believe, which doesn't work for me.
Thanks