Craig,

Thank you for your assistance. However, when I type your code into the "Adjusted_Export" column M I get the #VALUE! Yet again. I see what you are trying to do with the mid statement to extract the machine number but my sheet does not seem to like that. Also I have different modules that will break out in mid machine number. For example one of my cells might start with SH420-075 and got through SH450-320. So I have to use the entire machine number. I can disregard the first two alpha characters though so it would be 2 three digit numbers seperated by the hyphen.

I have the feeling that I am missing something with my book that keeps causing me to get the #VALUE! but I cannot find what it is.

Thanks for the quick reply!