Need assistance if possible.
I have a data set that is exported as digits, preceded by a letter, in this case F. This export format is hard wired into the program, so the alpha/numeric combo will remain in the dataset with every export and doesn't change letters or spacing, etc. I can already utilize either TRIM or RIGHT formulas to remove the preceding letter, and leave the raw numbers in a set of helper columns. However, I need to add these items together once trimmed of alpha characters and nothing has been able to return a result other than an error (0, #Value or #Error). Anyone have any thoughts? attached a basic sample of this set up for reference
