010:31ExcelBeginner
Open Copilot in Excel and pick a mode
You open Copilot in Excel and pick the right mode: edit, plan or just answer.
Catalogue · Excel and data with AI
Remove duplicates and split names
You remove duplicates from a list and split title, first name and last name in one request.
ExcelIntermediate0:48Capsule 4 of 11
SkillKapsul
Space: play · ← →: 5 seconds · M: sound · F: full screen
The steps
The exact sequence, in order.
- 01
Switch Copilot to Allow editing mode.
- 02
Ask it to find duplicates by email, then remove them.
- 03
Check the rows it suggests removing, then click Proceed.
- 04
Ask it to split the Full name column into three columns.
The prompt to copy
Word for word, exactly as shown in the video.
Find duplicate leads based on the Email column, show them to me, then remove the duplicates and keep the first row.
The habit to keep
Check the row count before and after.
Related capsules
You might also like
Newsletter
Monday's capsule
One skill a week, straight to your inbox. The easiest way to keep learning without thinking about it.
Your data stays in the EU. Never sold.