Objective:
Split the values in a cell from a CSV export
Environment:
Event Temple Web App
Microsoft Excel
Google Sheets
Procedure:
Use the steps outlined here to export your Booking information. Once your export is complete open it in Excel or in Google Sheets.
In Microsoft Excel
Select the cell or column that contains the text you want to split.
Select Data > Text to Columns.
In the Convert Text to Columns Wizard, select Delimited > Next.
Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.
Select Next.
Select the Column data format or use what Excel chose for you.
Select the Destination, which is where you want the split data to appear on your worksheet.
Select Finish.
The steps from Microsoft (including a Video) can be found here.
In Google Sheets
Select the cell or column that contains the text you want to split
At the top, click Data > Split text to columns
Click the dropdown menu next to "Separator" that populates in the Sheet
From the dropdown select Space
For the steps outlined by Google, please review this article.