开始使用免费开始使用

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.

本练习是课程的一部分

Microsoft Copilot in Excel

查看课程

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习