Skip to main content
All CollectionsReportsReports FAQ
How do I separate First and Last names into separate cells in my Bookings Export?
How do I separate First and Last names into separate cells in my Bookings Export?

Split the values in a cell from a CSV export

Updated over a week ago

Use the steps outlined here to export your Booking information. Once your export is complete open it in Excel or Google Sheets.

In Microsoft Excel

  1. Select the cell or column that contains the text you want to split.

  2. Select Data > Text to Columns.

  3. In the Convert Text to Columns Wizard, select Delimited > Next.

  4. Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.

  5. Select Next.

  6. Select the Column data format or use what Excel chose for you.

  7. Select the Destination, which is where you want the split data to appear on your worksheet.

  8. Select Finish.

The steps from Microsoft (including a Video) can be found here.

In Google Sheets

  1. Select the cell or column that contains the text you want to split

  2. At the top, click Data > Split text to columns

  3. Click the dropdown menu next to "Separator" that populates in the Sheet

  4. From the dropdown select Space

For the steps outlined by Google, please review this article.

Did this answer your question?