I think I got it.. It looks like it is either 7 thru 9 digits after the 3 letter prefix. I am going to take the first 9 and dump that in a column.. then take the first 8 where number like 's%' or 'c%', then first 7 from that.. then combine it all into 1 column..
Thanks... I will probaby have some more, because that is 1 out of 50 vendors.. Ahh, it's going to be a great weekend..
thanks again.