Excel & Sheets practice: Substring Extraction
Chapter 13 · 3 questions · included in full access
Question 1 · easy
City from location
Solve it in your browserReturn just the city from each Location (
Jaipur, RJ→Jaipur). Start in H2, fill to H9.Question 2 · medium
Email domain
Solve it in your browserExtract everything after the @ in each Email, in lower case (
Rahul.Sharma@GMAIL.com→gmail.com). Start in H2, fill to H9.Question 3 · easy
Invoice sequence number
Solve it in your browserPull out the four-digit sequence at the end of each Invoice (
INV-2025-0012→0012), keeping the leading zeros. Start in H2, fill to H9.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing