Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

TEXTSPLIT in Excel‼️

CheatSheets

232,134 subscribers

36,232 views • 2 years ago •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

6 Comments

CheatSheets2 years ago

Comment “SPLIT” and Click here to learn more. #excel #split #data #spreadsheet #analysis #corporate #accounting #finance

Ehiaghe Lewis2 years ago

Hello. How can I get the sheets you use for your videos. Thanks.

Ehiaghe Lewis2 years ago

SPLIT

Marshal killabyte2 years ago

@TweetHelperBot download this

Saran kumar2 years ago

Good

Xe Hà Trâm2 years ago

@Vitecfurniture

Related Videos

TEXTSPLIT in Excel‼️ #excel

TEXTSPLIT in Excel‼️ #excel

CheatSheets

26,197 views • 2 years ago

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 views • 2 years ago

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 views • 3 years ago

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

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

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

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

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

Count If in Excel‼️ #excel

Count If in Excel‼️ #excel

CheatSheets

24,477 views • 2 years ago

CF Borders in Excel‼️ #excel

CF Borders in Excel‼️ #excel

CheatSheets

28,338 views • 1 year ago

Org Chart in Excel‼️ #excel

Org Chart in Excel‼️ #excel

CheatSheets

50,265 views • 1 year ago

Text Split in Excel‼️ #excel

Text Split in Excel‼️ #excel

CheatSheets

14,126 views • 1 year ago

Table Slicers in Excel‼️ #excel

Table Slicers in Excel‼️ #excel

CheatSheets

39,394 views • 2 years ago

Time Worked in Excel‼️ #excel

Time Worked in Excel‼️ #excel

CheatSheets

47,436 views • 2 years ago

Remove Blanks in Excel‼️ #excel

Remove Blanks in Excel‼️ #excel

CheatSheets

71,042 views • 2 years ago

Progress Chart in Excel‼️ #excel

Progress Chart in Excel‼️ #excel

CheatSheets

47,459 views • 1 year ago

Replace Blanks in Excel‼️ #excel

Replace Blanks in Excel‼️ #excel

CheatSheets

21,925 views • 1 year ago