May 14 2021 09:53 AM
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?
May 14 2021 11:41 AM
@KFilbert Why not upload an example of your "inconsistent and free-form data" and explain how you would want to have it separated? Based on your question alone, I'm afraid, you will not get much help.