CommencerCommencez gratuitement

Extract region and department from ticket IDs

You'll be working on a table called SupportTickets. The Ticket ID column contains structured codes like EMEA-SALES-0042, where the first segment is the region, the second is the department, and the third is a numeric ID.

Over this exercise and the next, you'll clean-up this data to prepare it for analysis, starting by separating the Region and Department columns.

Cet exercice fait partie du cours

<cours>Microsoft Copilot in Excel</cours>
Voir le cours

Exercice interactif pratique

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice