How to split text values in Excel with formulas - Quick Solution ⏳

Опубликовано: 05 Октябрь 2024
на канале: Chandoo

27,282

1.1k

Have you tried the new TEXTSPLIT function in Excel? It is crazy I tell you.

We can use it to split text to multiple value. For example,

👉 Got a full name in a cell and need to split first name & last name? TEXTSPLIT() it
👉 Have some email addresses in a cell and need to separate them? TEXTSPLIT to the rescue
👉 Working late because you don't know how to use Excel and your partner hates you for that? You can either split or try some of that juicy TEXTSPLIT... 🤣

Let me show you how to use TEXTSPLIT with one simple and two advanced examples.

~

Learn more about some of the most useful & time-saving features of Excel.

My top 10 - I Saw my boss do this in Excel (Almost 2 mn views) -    • I saw my boss do these 10 things in E...
How to use IF formula in Excel -    • 5 Advanced Tips on how to use IF form...
10 Advanced tips on IF formula -    • 10 Advanced IF formulas every analyst...
How to use FILTER in Excel -    • I don’t use filters in Excel anymore....
How to use XLOOKUP in Excel -    • I don't use VLOOKUP anymore. I use th...

More videos on Excel Formulas -    • 10 Advanced IF formulas every analyst...

~

#excel #textsplit