[EMS] How to generate access tokens in Excel

How to generate access token from EMS attendee list: 

1. Export selected attendee list
2. Add a new column next to "Ticket Url" 
3. Insert formula =SUBSTITUTE(text, old text, new text)

      4. Copy the formula for the entire list