Problem:

I have an excel spreadsheet I am trying to prepare for a data import into one of Evosus' templates.  The original excel file has data combined into one cell that I need to split into another. For example, the Customer Address field has City and State in one column but I need it split into city and state separately into two columns for the Customer/Lead Import.  The data in the column is split by a comma. 

Resolution:

Using this KB article from Microsoft, you can use the tool called Text to Columns to split data in a cell based on comma, space or a special character.

https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7