Loading video...

Video Failed to Load

Go Home

Separate Names and Units Sold from Messy Data having Multiple Delimiters | TEXTSPLIT Function in #Excel 365 =TRIM(TEXTSPLIT(B5,"-",{",",";","/"}))

ExcelBasement's profile picture

Excel Basement

34,394 subscribers

46,808 views • 3 years ago •via X (Twitter)

EducationScience & Technology#Excel
LIVE

Anya Rossi• Live Now

Private livecam show

4 Comments

Sir Odutola King's profile picture
Sir Odutola King3 years ago

Can't wait to get back on excel 😍

Emmanaira's profile picture
Emmanaira3 years ago

Can the excel that’s not 365 do this ?

Devon's's profile picture
Devon's3 years ago

Do u have the function for Excel Spanish?

Gabriel's profile picture
Gabriel3 years ago

I can't get the TextSplit function in Spanish

Related Videos

How to Split Text with Multiple Delimiters in Microsoft #Excel | TEXTSPLIT Function
0:56

How to Split Text with Multiple Delimiters in Microsoft #Excel | TEXTSPLIT Function

Excel Basement

173,555 views • 3 years ago

Count / Sum Multiple Values in a Cell (Excel 365 Version) =COUNT(--TEXTSPLIT(MID(B5,2,LEN(B5)-2),{",","&"})) =SUM(--TEXTSPLIT(MID(B10,2,LEN(B10)-2),{",","&"})) =COUNTA(--TEXTSPLIT(MID(B14,2,LEN(B14)-2),{",","&"}))
0:54

Count / Sum Multiple Values in a Cell (Excel 365 Version) =COUNT(--TEXTSPLIT(MID(B5,2,LEN(B5)-2),{",","&"})) =SUM(--TEXTSPLIT(MID(B10,2,LEN(B10)-2),{",","&"})) =COUNTA(--TEXTSPLIT(MID(B14,2,LEN(B14)-2),{",","&"}))

Excel Basement

23,102 views • 2 years ago

How to Extract Numbers only with Comma Delimiter from a Cell in Microsoft #Excel 365 =TEXTJOIN(", ",,TEXTSPLIT(B5,TEXTSPLIT(B5,SEQUENCE(10,,0),,1),,1)) Thanks to Rick Rothstein for Solution
0:29

How to Extract Numbers only with Comma Delimiter from a Cell in Microsoft #Excel 365 =TEXTJOIN(", ",,TEXTSPLIT(B5,TEXTSPLIT(B5,SEQUENCE(10,,0),,1),,1)) Thanks to Rick Rothstein for Solution

Excel Basement

11,193 views • 2 years ago

📊 Master the TEXTSPLIT Function in Excel Still separating text manually? The TEXTSPLIT function lets you split text into multiple columns or rows instantly using a delimiter such as commas, spaces, hyphens, or other characters. Why TEXTSPLIT is Useful ✅ Clean messy datasets faster ✅ Separate names, emails, and addresses automatically ✅ Save time on repetitive text processing ✅ Improve data preparation for analysis ✅ Replace manual Text-to-Columns workflows (Save this for later).
0:25

📊 Master the TEXTSPLIT Function in Excel Still separating text manually? The TEXTSPLIT function lets you split text into multiple columns or rows instantly using a delimiter such as commas, spaces, hyphens, or other characters. Why TEXTSPLIT is Useful ✅ Clean messy datasets faster ✅ Separate names, emails, and addresses automatically ✅ Save time on repetitive text processing ✅ Improve data preparation for analysis ✅ Replace manual Text-to-Columns workflows (Save this for later).

Tips Excel

18,005 views • 2 months ago

How to use TEXTSPLIT in Excel‼️ ❤️ and follow CheatSheets for daily tips‼️ #excel
0:30

How to use TEXTSPLIT in Excel‼️ ❤️ and follow CheatSheets for daily tips‼️ #excel

CheatSheets

98,096 views • 2 years ago

Separate Text And Numbers In Excel From Mixed Data - No Formula Method Subscribe: #excel #learnexcel #exceltips #exceltricks #exceltutorials #office #Office365
0:55

Separate Text And Numbers In Excel From Mixed Data - No Formula Method Subscribe: #excel #learnexcel #exceltips #exceltricks #exceltutorials #office #Office365

Learn Excel to excel

16,208 views • 7 months ago

Extract First, Middle & Last Names from a list of Names in Microsoft #Excel 365 First Name: =TEXTBEFORE(B4," ") Middle Name: =IFNA(TEXTBEFORE(TEXTAFTER(B4, " "), " "),"") Last Name: =TEXTAFTER(B4," ",-1)
0:49

Extract First, Middle & Last Names from a list of Names in Microsoft #Excel 365 First Name: =TEXTBEFORE(B4," ") Middle Name: =IFNA(TEXTBEFORE(TEXTAFTER(B4, " "), " "),"") Last Name: =TEXTAFTER(B4," ",-1)

Excel Basement

20,409 views • 2 years ago

How to combine multiple data files and summarize them in less than 30 seconds. 🤯 #excel
0:29

How to combine multiple data files and summarize them in less than 30 seconds. 🤯 #excel

Excel Dictionary

312,380 views • 3 years ago

🚀 Stop Merging Data Manually in Excel! 📊 😫 Still copying and pasting data from multiple tables? There’s a smarter way. ⚡ Excel’s Consolidate feature lets you combine data from multiple ranges into a single summary in just a few clicks—saving time and reducing errors. ✅ Merge data faster ✅ Eliminate repetitive manual work ✅ Improve accuracy and productivity ✅ Perfect for reports, budgeting, and data analysis 💡 Small Excel tricks like this can save you hours over the course of a year. 📌 Save this post so you don’t forget it when working with spreadsheets! ❤️ Like • 🔄 Repost • 💬 Share with someone who still copies and pastes data manually.
0:36

🚀 Stop Merging Data Manually in Excel! 📊 😫 Still copying and pasting data from multiple tables? There’s a smarter way. ⚡ Excel’s Consolidate feature lets you combine data from multiple ranges into a single summary in just a few clicks—saving time and reducing errors. ✅ Merge data faster ✅ Eliminate repetitive manual work ✅ Improve accuracy and productivity ✅ Perfect for reports, budgeting, and data analysis 💡 Small Excel tricks like this can save you hours over the course of a year. 📌 Save this post so you don’t forget it when working with spreadsheets! ❤️ Like • 🔄 Repost • 💬 Share with someone who still copies and pastes data manually.

Tips Excel

558,039 views • 2 months ago

Microsoft has just announced Copilot's ability to process data in Excel by generating Python code. - Request a detailed analysis - Copilot generates Python - Excel executes the code to show the result All without having to write a single formula. Just natural language. Huge deal for data analysis and visualization.
1:09

Microsoft has just announced Copilot's ability to process data in Excel by generating Python code. - Request a detailed analysis - Copilot generates Python - Excel executes the code to show the result All without having to write a single formula. Just natural language. Huge deal for data analysis and visualization.

Paul Couvert

373,713 views • 1 year ago

How to Transfer data from PDF in Excel‼️ ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet
0:22

How to Transfer data from PDF in Excel‼️ ❤️ and follow for daily tips! 🗂️ Save this post for future reference! 👯 Share it with a friend! #cheatsheets #excel #exceltips #googlesheets #spreadsheet

CheatSheets

11,393 views • 9 months ago

From rough ideas to quality work. OpenAl's GPT-5.6 is rolling out across Microsoft 365 Copilot in Word, Excel, PowerPoint, Chat, and Copilot Cowork. Optimized with OpenAl for knowledge work, GPT-5.6 is the preferred model for Microsoft 365 Copilot.
0:24

From rough ideas to quality work. OpenAl's GPT-5.6 is rolling out across Microsoft 365 Copilot in Word, Excel, PowerPoint, Chat, and Copilot Cowork. Optimized with OpenAl for knowledge work, GPT-5.6 is the preferred model for Microsoft 365 Copilot.

Microsoft 365

35,458 views • 1 month ago

ChatGPT is now available as an add-on in Excel and Google Sheets. It can help analyze messy data, write formulas, update spreadsheets, and explain what it’s doing along the way—without leaving your spreadsheet. Powered by GPT-5.5.
0:51

ChatGPT is now available as an add-on in Excel and Google Sheets. It can help analyze messy data, write formulas, update spreadsheets, and explain what it’s doing along the way—without leaving your spreadsheet. Powered by GPT-5.5.

ChatGPT

970,155 views • 3 months ago

For me, our Analyst agent in Microsoft 365 Copilot is like having a skilled data analyst on hand — all the time. It generates insights and helps you visualize complex data. Here's a quick demo on how it can make sense of marketing campaign data and help you get more done at work.
0:46

For me, our Analyst agent in Microsoft 365 Copilot is like having a skilled data analyst on hand — all the time. It generates insights and helps you visualize complex data. Here's a quick demo on how it can make sense of marketing campaign data and help you get more done at work.

Satya Nadella

350,674 views • 11 months ago

when nicki was surprised with multiple plaques and new certifications from Republic Records during her sold out show in Newark.
1:15

when nicki was surprised with multiple plaques and new certifications from Republic Records during her sold out show in Newark.

diego

28,172 views • 1 month ago

❗️🇺🇦Ukrainian soldiers from the 33rd and 1st Separate Assault Regiments, together with attached units, stopped an attempted 🇷🇺Russian offensive on the village of Dobropillia in Zaporizhzhia Oblast.
1:53

❗️🇺🇦Ukrainian soldiers from the 33rd and 1st Separate Assault Regiments, together with attached units, stopped an attempted 🇷🇺Russian offensive on the village of Dobropillia in Zaporizhzhia Oblast.

🪖MilitaryNewsUA🇺🇦

17,281 views • 6 months ago

According to this person, Alberta cannot legally separate from Canada. I'm not an expert at all in treaty, unceded, stolen land issues. But using multiple articles from the CBC to prove your point does not at up for having a solid argument.
1:57

According to this person, Alberta cannot legally separate from Canada. I'm not an expert at all in treaty, unceded, stolen land issues. But using multiple articles from the CBC to prove your point does not at up for having a solid argument.

The Real Mr Bench

37,540 views • 1 year ago