Trebor76 I found this thread in search to the very thing you posted. I was able to use the code you provided but ran into a problem. I have values in the "A" column that are numbers and letters for example (0B, LL1, LL2, 6M) Using your code the letters disappear if they are after numbers for example (0B turns into 0) and (6M turns into 6) is there any way to adjust for this?

Thanks for your time and help!!