AnalystReps

Excel & Sheets practice: Delimiter Splitting & Text Assembly

Chapter 14 · 2 questions · included in full access

  1. Question 1 · medium

    Split the SKU — Excel

    Split the SKU in F2 (ACP-SLV-4MM) into its three parts, spilling across from H2.

    Solve it in your browser

  2. Question 2 · medium

    Split the SKU — Google Sheets

    In Google Sheets, split the SKU in F8 (RIV-BOX-100) into its parts, spilling across from H8. Notice what type the last part comes back as.

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing