正在加载视频...

视频加载失败

返回首页

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 次观看 • 3 年前 •via X (Twitter)

教育科学技术#Excel
LIVE

Anya Rossi• Live Now

Private livecam show

4 条评论

Sir Odutola King 的头像
Sir Odutola King3 年前

Can't wait to get back on excel 😍

Emmanaira 的头像
Emmanaira3 年前

Can the excel that’s not 365 do this ?

Devon's 的头像
Devon's3 年前

Do u have the function for Excel Spanish?

Gabriel 的头像
Gabriel3 年前

I can't get the TextSplit function in Spanish

相关视频

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 次观看 • 3 年前

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 次观看 • 2 年前

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 次观看 • 2 年前

📊 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 | AI Productivity

18,112 次观看 • 2 个月前

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 次观看 • 2 年前

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 次观看 • 7 个月前

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 次观看 • 2 年前

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 次观看 • 3 年前

🚀 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 次观看 • 2 个月前

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,808 次观看 • 1 年前

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 次观看 • 10 个月前

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,564 次观看 • 1 个月前

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 次观看 • 3 个月前

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 次观看 • 11 个月前

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,187 次观看 • 1 个月前

❗️🇺🇦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 次观看 • 6 个月前

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 次观看 • 1 年前