Hello Mr. Excel community,
I have a small project that seems to be beating me and I need your help. I have a column of data that could be letters and numbers or all numbers (PartNo). I would like to change the value to the first 5 characters (Base5). I can do this as a formula in Excel, but my...