Split Values in Column: 5 Amazing Methods

by excelisfun · 5 videos

Total watch time

24m 43s

at 1× speed · exactly 24 minutes, 43 seconds at 1×

custom

1×	24m 43s
1.25×	19m 46s
1.5×	16m 29s
1.75×	14m 7s
2×	12m 22s

Average video4m 57s

Longest7m 43s

Shortest2m 34s

Compare Open on YouTube JSON

Plan to finish

About 1 day at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 1 day. Turn on JavaScript to plan around your week.

Videos (5)

24m 43s in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.


1	The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908	7:43	2025-09-16
2	Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907	3:40	2025-09-12
3	Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906	5:35	2025-09-11
4	Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905	2:34	2025-09-10
5	Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904	5:11	2025-09-09

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Markdown

[![Watch time: 24m 43s · 5 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0kvGUtN3lRyNbiCmYURc9_m.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0kvGUtN3lRyNbiCmYURc9_m)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0kvGUtN3lRyNbiCmYURc9_m"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0kvGUtN3lRyNbiCmYURc9_m.svg" alt="Watch time: 24m 43s · 5 videos" width="202" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0kvGUtN3lRyNbiCmYURc9_m returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.