I have an excel sheet that has multiple pieces of information in 1 column that needs to be separated into multiple unique columns in order to import into another system.
The information is not consistent in any way. It comes from database field that was just free form both in terms of info to capture and spacing. In one column I can have name and company, and I have columns where where in addition to basic contact info there address and other information included
So a convert to columns function does not work (well I suppose it could but still requires significant manual intervention)
What other functions/formulas/options are available?