Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricks
Loading...
Loading...
8:54
Excel Magic Trick 288: Count Character or Nums. In Text Stringby ExcelIsFun3,182 views- 6:11
Excel Magic Trick 290: Count Codes From Column of Text Stringsby ExcelIsFun1,352 views
- 6:01
Excel Magic Trick 332: Insert Text with REPLACE functionby ExcelIsFun7,122 views
- 6:55
Excel Magic Trick 291: Add Nums Associated w Codes From Stringby ExcelIsFun989 views
- 5:19
Excel Name Trick #7: INDIRECT function, Names and LOOKUPby ExcelIsFun67,939 views
- 2:09
Random Sorting of Data in Excelby oversharingterri1,567 views
- 4:11
Excel Magic Trick 318: MID Text (substring) VLOOKUP Troubleby ExcelIsFun4,340 views
- 27 videos30 Excel Functions
- 12:55
Excel Magic Trick 308: Extract Data To New Workbook W Formulaby ExcelIsFun8,383 views
- 4:06
Change Text with Excel SUBSTITUTE Functionby contextures986 views
- 10:22
Excel Magic Trick 315: SUMIF Only Accept Ranges, Not Arraysby ExcelIsFun5,500 views
- 9:25
Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIFby ExcelIsFun6,016 views
- 15:42
Excel Magic Trick 337: RANK function 10 Examplesby ExcelIsFun11,563 views
- 9:16
Excel Magic Trick 317: MID function: Pattern Recognitionby ExcelIsFun5,202 views
- 8:52
Excel Magic Trick 313: Some Facts About Array Formulasby ExcelIsFun3,516 views
- 6:26
Excel Magic Trick 306: MCONCAT LOOKUP functions (CAT = 593)by ExcelIsFun2,352 views
- 5:13
Excel Magic Trick 312: Extract Date & Time From Text Stringby ExcelIsFun5,823 views
- 7:31
Excel Magic Trick 324: Dynamic Data Validation List of Datesby ExcelIsFun10,396 views
- 10:31
Excel Magic Trick 167p1 IF function formula: 12 Examples!by ExcelIsFun167,971 views
- 7:25
Excel Magic Trick 297.5: Conditional Sum for Varying Columnsby ExcelIsFun3,266 views
- 6:10
Excel Magic Trick 309: Partial Text Match: Why 2^15?by ExcelIsFun4,393 views
Search for and watch this video title:
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks
ExcelIsFun 1 year ago
kindly give me above worksheet in Excel.
raja10pk 1 year ago
Dear dukeofscouts,
The logic of all these tricks is to find some pattern to exploit. We found commas as our pattern.
The 5 numbers that are not zero are: 5 and 658 and 9 87 and 1.
To count the individual characters that are numbers, use this:
LEN(SUBSTITUTE(SUBSTITUTE(B19,",0",""),",","")
What are you trying to accomplish with the AND and SUBSTITUTE?
--excelsifun
ExcelIsFun 2 years ago
How was the last count 5? I count 8 numbers.
Also can you use the AND function with a substitute?
dukeofscouts 2 years ago