Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

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

gudanglifehack's profile picture

Tips Excel

472,551 subscribers

16,933 görüntüleme • 21 gün önce •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

0 Yorum

Yorum bulunmuyor

Orijinal gönderinin yorumları burada görünecek

Benzer Videolar

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

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

Excel Basement

46,808 görüntüleme • 3 yıl önce

🚀 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

557,428 görüntüleme • 16 gün önce

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
0:29

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 görüntüleme • 2 yıl önce

Text-to-Columns in Excel 💬
0:30

Text-to-Columns in Excel 💬

CheatSheets

94,787 görüntüleme • 1 yıl önce

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 görüntüleme • 2 yıl önce

Text to Columns Shortcut in Excel‼️ #excel
0:22

Text to Columns Shortcut in Excel‼️ #excel

CheatSheets

24,375 görüntüleme • 1 yıl önce

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

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 görüntüleme • 2 yıl önce

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

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 görüntüleme • 3 yıl önce

TEXTSPLIT in Excel‼️ #excel
0:30

TEXTSPLIT in Excel‼️ #excel

CheatSheets

23,265 görüntüleme • 1 yıl önce

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 ✅
0:46

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 görüntüleme • 1 yıl önce

TEXTSPLIT in Excel‼️ #excel
0:27

TEXTSPLIT in Excel‼️ #excel

CheatSheets

26,173 görüntüleme • 1 yıl önce

TEXTSPLIT in Excel‼️
0:30

TEXTSPLIT in Excel‼️

CheatSheets

35,989 görüntüleme • 1 yıl önce

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 görüntüleme • 2 yıl önce

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

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

Paul Couvert

170,196 görüntüleme • 3 yıl önce

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

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

Mike Tholfsen

44,697 görüntüleme • 3 yıl önce

🚀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
0:47

🚀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 görüntüleme • 1 yıl önce

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

97,958 görüntüleme • 2 yıl önce

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

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 görüntüleme • 2 ay önce

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

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

Tips Excel

21,454 görüntüleme • 2 ay önce

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
0:22

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 görüntüleme • 11 ay önce