Ok I have a few instances where I need to ignore a - and numbers after it for instance 12345-0001. I understand how to use left and find to clean this up. Now there are some occasions when I will have a string of numbers like 12345-01-0001. I need the first -01, but ignore the rest so it would read 12345-01. So I need something dynamic in that sense. I've tried a few things I'm to embarrassed to post, any suggestions?