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. 


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.