正在加载视频...

视频加载失败

加载此视频时出现问题。这可能是由于临时网络问题，或视频可能不可用。

📊 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... show more

Tips Excel

472,551 subscribers

16,933 次观看 • 21 天前 •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

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

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

Excel Basement

46,808 次观看 • 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.

🚀 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

557,428 次观看 • 16 天前

Extract TEXT only from Cell in Microsoft #Excel 365 Version =TEXTJOIN(" ",,TEXTSPLIT(B5,TEXTSPLIT(B5,CHAR(SEQUENCE(,26,65)),,1,1),,1)) Thanks to Rick Rothstein (LINKEDIN) for Solution

Extract TEXT only from Cell in Microsoft #Excel 365 Version =TEXTJOIN(" ",,TEXTSPLIT(B5,TEXTSPLIT(B5,CHAR(SEQUENCE(,26,65)),,1,1),,1)) Thanks to Rick Rothstein (LINKEDIN) for Solution

Excel Basement

14,474 次观看 • 2 年前

Text-to-Columns in Excel 💬

Text-to-Columns in Excel 💬

CheatSheets

94,787 次观看 • 1 年前

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

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 年前

Text to Columns Shortcut in Excel‼️ #excel

Text to Columns Shortcut in Excel‼️ #excel

CheatSheets

24,375 次观看 • 1 年前

How to Extract the TOP Marks Attained in Microsoft #EXCEL 365 =MAX(--TEXTSPLIT(TEXTJOIN(", ",,TEXTSPLIT(C4,TEXTSPLIT(C4,SEQUENCE(10,,0),,1),,1)),", "))

How to Extract the TOP Marks Attained in Microsoft #EXCEL 365 =MAX(--TEXTSPLIT(TEXTJOIN(", ",,TEXTSPLIT(C4,TEXTSPLIT(C4,SEQUENCE(10,,0),,1),,1)),", "))

Excel Basement

25,565 次观看 • 2 年前

How to text to columns in Excel! 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

How to text to columns in Excel! 🗂️ Don’t forget to save this post! #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

CheatSheets

326,570 次观看 • 3 年前

TEXTSPLIT in Excel‼️ #excel

TEXTSPLIT in Excel‼️ #excel

CheatSheets

23,265 次观看 • 1 年前

CSS Scroll-driven knockout text using SVG filter 🥊 section { filter: url(#knockout); } section h1 { animation: shrink; } @keyframes shrink { 0% { scale: 36; }} Animate text scale on a video overlay ✅ Knock out text using SVG filter ✅ Drive with scroll ✅

CSS Scroll-driven knockout text using SVG filter 🥊 section { filter: url(#knockout); } section h1 { animation: shrink; } @keyframes shrink { 0% { scale: 36; }} Animate text scale on a video overlay ✅ Knock out text using SVG filter ✅ Drive with scroll ✅

jhey ʕ•ᴥ•ʔ

100,075 次观看 • 1 年前

TEXTSPLIT in Excel‼️ #excel

TEXTSPLIT in Excel‼️ #excel

CheatSheets

26,173 次观看 • 1 年前

TEXTSPLIT in Excel‼️

TEXTSPLIT in Excel‼️

CheatSheets

35,989 次观看 • 1 年前

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),{",","&"}))

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 年前

Compose AI Write your emails or any text faster. This AI makes suggestions in real time in all text fields.

Compose AI Write your emails or any text faster. This AI makes suggestions in real time in all text fields.

Paul Couvert

170,196 次观看 • 3 年前

This Micro Tip will show you how to used Text to Columns in Excel (Advanced mode) 👉 #edtech #STEM #Excel

This Micro Tip will show you how to used Text to Columns in Excel (Advanced mode) 👉 #edtech #STEM #Excel

Mike Tholfsen

44,697 次观看 • 3 年前

🚀Napkin AI visuals just got better! We’ve launched Elastic Designs to help you get the right visual, faster. Now your visuals: ✅ Scale automatically with your content – during both generation and editing – so they always look polished without manual fixes ✅ Support more elements than ever, so none of your content gets dropped-off ✅ Instantly update with one-click Visual-Text sync when you change your text – no need to regenerate This is a big step toward making visual generation effortless – so you spend less time tweaking visuals and get to the right one faster. #NapkinAI #VisualAI #AITools #ElasticDesigns #NewFeatures

🚀Napkin AI visuals just got better! We’ve launched Elastic Designs to help you get the right visual, faster. Now your visuals: ✅ Scale automatically with your content – during both generation and editing – so they always look polished without manual fixes ✅ Support more elements than ever, so none of your content gets dropped-off ✅ Instantly update with one-click Visual-Text sync when you change your text – no need to regenerate This is a big step toward making visual generation effortless – so you spend less time tweaking visuals and get to the right one faster. #NapkinAI #VisualAI #AITools #ElasticDesigns #NewFeatures

Napkin AI

51,337 次观看 • 1 年前

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

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

CheatSheets

97,958 次观看 • 2 年前

Get our Tradingview Real-Time News Extension for Chrome and Firefox, now with: ✅Text headlines ✅Voice squawk ✅TickStrike orderflow ✅ Calendar Chrome > FireFox >

Get our Tradingview Real-Time News Extension for Chrome and Firefox, now with: ✅Text headlines ✅Voice squawk ✅TickStrike orderflow ✅ Calendar Chrome > FireFox >

FinancialJuice

2,717,744 次观看 • 2 个月前

Text to Columns Wizard ❤️ and follow for daily tips!🗂️

Text to Columns Wizard ❤️ and follow for daily tips!🗂️

Tips Excel

21,454 次观看 • 2 个月前

How to clean messy data using the new REGEXREPLACE function. 😲 Save your seat now for the FREE EXCEL CLASS Miss Excel and I are hosting: #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorial #sheets

How to clean messy data using the new REGEXREPLACE function. 😲 Save your seat now for the FREE EXCEL CLASS Miss Excel and I are hosting: #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorial #sheets

Excel Dictionary

16,524 次观看 • 11 个月前