시작하기무료로 시작하기

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

강의 보기

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작