A little secret to rock your YouTube subscribers

Get Free YouTube Subscribers, Views and Likes

TEXTSPLIT Hack to make it Dynamic

Follow

Access Analytic

The new TEXTSPLIT function in Excel is one of 14 new functions just released.
Here's my hack to make it fully dynamic.

Excel Blog Post
https://techcommunity.microsoft.com/t...

Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/

posted by colorastefm

Excel Hash Sign Operator What is it + ADVANCED Tricks!

Excel Hash Sign Operator What is it + ADVANCED Tricks!

New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips)

New Excel TEXTSPLIT Function to Separate words with Ease (includes cool tips)

What is Microsoft Fabric? A simple explanation for nontechnical people.

What is Microsoft Fabric? A simple explanation for nontechnical people.

An awesome trick to compare 2 Excel ranges and flag the differences

An awesome trick to compare 2 Excel ranges and flag the differences

Split by Variable Columns in Power Query

Split by Variable Columns in Power Query

Excel TEXTSPLIT Function Split Names, Get First, Last Word, Split by Character

Excel TEXTSPLIT Function Split Names, Get First, Last Word, Split by Character

5 ways to export data from Power BI

5 ways to export data from Power BI

The Best Way To Split Text In Excel

The Best Way To Split Text In Excel

How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next Project

How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next Project

Remove Blank Rows/Columns with Power Query Incl. STUBBORN Characters!

Remove Blank Rows/Columns with Power Query Incl. STUBBORN Characters!

3 NEW Excel Text Functions I wish I had years ago!

3 NEW Excel Text Functions I wish I had years ago!

TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785

TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785

Excel Dynamic Arrays (How they will change EVERYTHING!)

Excel Dynamic Arrays (How they will change EVERYTHING!)

Split Text to Rows in Excel (3 Easy Ways)

Split Text to Rows in Excel (3 Easy Ways)

Easy Excel Forms No VBA & access from any device!

Easy Excel Forms No VBA & access from any device!

10 Million Rows of data Analyzed using Excel's Data Model

10 Million Rows of data Analyzed using Excel's Data Model

Dynamic Filter in Excel Filter As You Type (with & without VBA)

Dynamic Filter in Excel Filter As You Type (with & without VBA)

Dynamic Array Formulas And Spill Ranges: How To Use Them In Excel Tables

Dynamic Array Formulas And Spill Ranges: How To Use Them In Excel Tables

How to SIMPLIFY DAX using Power Query

How to SIMPLIFY DAX using Power Query

Stop using VLOOKUP in Excel. Switch to INDEX MATCH

Stop using VLOOKUP in Excel. Switch to INDEX MATCH

Recommended

Kittens - Best Pill To Cure Stress

Kittens - Best Pill To Cure Stress

03:05

Diving into 1000 Mousetraps - What Can Be More Relaxing?

Diving into 1000 Mousetraps - What Can Be More Relaxing?

06:21

Fantastic Presents & Where To Find Them

Fantastic Presents & Where To Find Them

04:01

If Guys Made Typical Girls' Tricks

If Guys Made Typical Girls' Tricks

01:04

How To Make Yoru Curry Taste Like Meat...Without It

How To Make Yoru Curry Taste Like Meat...Without It

10:03

This Is Exactly What Every Hotel Is Like

This Is Exactly What Every Hotel Is Like

05:09

Amazing Craft Beer Chemistry That You Won't Be Taught At School

Amazing Craft Beer Chemistry That You Won't Be Taught At School

03:07

Cheat Or Chat Challenge For Experienced Couples!

Cheat Or Chat Challenge For Experienced Couples!

02:59