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.
Unless explicitly stated, this topic documents the most recent version of Evosus Business Enterprise. If you're not using the latest version, go here to download it.
Did you find it helpful?Send feedback