Загрузка видео...

Не удалось загрузить видео

На главную

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

18,005 просмотров • 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 просмотров • 6 месяцев назад

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,713 просмотров • 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 просмотров • 9 месяцев назад

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,452 просмотров • 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 просмотров • 10 месяцев назад

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 просмотров • 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 год назад