Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. Text & Dates

Excel Text Functions Practice: CONCAT, LEFT, MID, RIGHT, TRIM, Split Cells

Join names, extract SKU parts, split emails and clean padded text.

5 exercises, about 28 min

  1. 42Full name with CONCAT or &Beginner~4 minBeginner, ~4 min
  2. 43Extract category, year and serial from SKUBeginner~6 minBeginner, ~6 min
  3. 44Split email into user and domain (FIND/LEFT/RIGHT or TEXTBEFORE/TEXTAFTER)Intermediate~7 minIntermediate, ~7 min
  4. 45Clean padded, lower-case names with TRIM and PROPERIntermediate~6 minIntermediate, ~6 min
  5. 46Combine tags per product with TEXTJOINIntermediate~5 minIntermediate, ~5 min