We have a data dump that brings our item numbers into the cells as "000043F". I am trying to write a formula where if the right character is F, so one and so forth. The problem is no LEFT or RIGHT formula works on this cell at all. I have tried TRIM, TEXT and nothing works. Usually this happens when there is an extra space, but in this case there are NO exptra spaces in the front or end. However, if I add one space to the end but hit backspace twice it lands me at the very end. It's almost like there is a hidden space in there??? What can I do? Example of what it looks like below: