Excel Magic Trick 489: Extract Only Numbers From Text String Array Formula
Loading...
Loading...
9,222
Loading...
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (31)
-
i have problem here ( first of all sry about my possible errors in english) when i type this formula i have an error. When i hit enter it highlight me part of formula where is A6,LARGE at the start of the formula. if anyone knows a solution pls help...thx
-
Could you post the actual formula as text here? I can't seam to make it work
-
Try posting your question to THE best Excel site:
mrexcel[dot]com
I am sure that you will get a great answer.
-
This does not seem to work if you have decimals e.g <0.2348 JH
Loading...
- 12:17
Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errorsby ExcelIsFun9,537 views
- 8:12
Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods)by ExcelIsFun5,852 views
- 5:27
Excel Magic Trick 490: Conditional Format for Budget Less Than $500.by ExcelIsFun2,510 views
- 7:01
Excel Magic Trick 492: Count Matches in Single Cellby ExcelIsFun1,364 views
- 5:44
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks and more...by ExcelIsFun445,220 views
- 3:45
Be Human Calculatorby glad2teach1,493,855 views
- 2:09
Numbering Records - Iby MrExcel31,503 views
- 11:33
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Throughby ExcelIsFun12,444 views
- 12:01
Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclatureby ExcelIsFun7,554 views
- 25:52
Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methodsby ExcelIsFun3,806 views
- 8:05
Excel Magic Trick 534: Conditional Formatting for Weekends and Holidaysby ExcelIsFun25,697 views
- 9:17
Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble Shoot Formula Creationby ExcelIsFun5,722 views
- 8:55
Excel Magic Trick 526: Grading Pass / Fail or Letter Grade Formula IF, AND, VLOOKUP functionsby ExcelIsFun11,036 views
- 10:44
Excel Magic Trick #507: Fix Bad Data So We Can Add With Two Criteria & Make Summary Reportby ExcelIsFun4,088 views
- 8:51
Excel Magic Trick #126: Macro: Advanced Filter Extract Textby ExcelIsFun47,449 views
- 5:25
Excel Magic Trick 482: 2 Pivot Tables with Different Date Groupings On Same Sheetby ExcelIsFun9,219 views
- 4:52
Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekendsby ExcelIsFun6,361 views
- 5:50
Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Methodby ExcelIsFun4,242 views
- 10:11
Excel MT142 p2: Array Formula for Counting Datesby ExcelIsFun9,243 views
- 13:58
Excel Magic Trick 100: Instead of Long IF, Use MEDAIN function Commission W Hurdle Calculationby ExcelIsFun6,519 views
This was beastly. Thanks.
hombreazu1 4 weeks ago
@hombreazu1 , You are welcome!
ExcelIsFun 4 weeks ago
Heyyy !!
How do i delete the same words off my own column ??
Sorry for being so rude.
but really urgenttt
THANKS in advance (:
lamenooby 2 months ago
@lamenooby , YouTube is not a good place to have discussions to get Excel solutions. Try THE best Excel question site:
mrexcel [dot] com/forum
This site is not affiliated with the excelisfun YouTube site, but it is THE place to ask questions.
ExcelIsFun 2 months ago
Awesome vid! I have successfully used on one worsheet but on another, It doesn't seem to calculate when I hit cntr+shift+enter. The formula goes to black text and is showing in the cell. But if I hit F9 the correct solution appears. Any thoughts on what I'm doing wrong?
omiuno 8 months ago
The only thing that I can think of is that the calculations is set to Manual. If you set it to Automatic it should work. Excel 2003: Options. Excel 2007 / 2010: Formula Ribbon tab.
ExcelIsFun 8 months ago