Separate numerical and text values of differing lengths from a single cell into separate columns
How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a numerical value. The numerical values to the left are of differing lengths, making this problematic. The provided image here is what I have done manually, but I would like for this to be in the form of a formula or function.
Help Article Resources
Check out the Formula Handbook template!