Event Tips - Splitting Additional Info/Data in Excel

This article will help show to split the Additional Info/Data on Excel after exporting data from Events in WebEd.

STEP-BY-STEP
  • 1
    Open the newly exported Excel file > Go to the Additional Data Column > Highlight the entire column
    Delete a Ticket Pool
  • 2
    Click on Data at the top menu
    Events Separating Columns
  • 3
    Click on the Text to Columns button/option on the top menu panel
    Events Separating Columns
  • 4
    A Pop up will appear for the settings.
  • 5
    Click on the Delimited option > Click Next.
    Events Separating Columns
  • 6
    Under Delimiters, tick on Tab, Semicolon, and Comma. Then click Next.
    Events Separating Columns
  • 7
    Under Column data format click on General then click on Finish.
    Events Separating Columns
  • 8
    The Data under Additional Data should now be split into different columns.
    Events Separating Columns