Split Text in MS Excel Column on Space, Comma, or Other Character
Issue:
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
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