Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula

preview_player
Показать описание

See how to take a list of menu items with unwanted text after the dash and remove the unwanted text using:
1. (00:08) Flash Fill (Excel 2013 only)
2. (01:01) Flash Fill and keyboard Ctrl + E (Excel 2013 only)
3. (01:24) Test To Columns
4. (02:09) LEFT and SEARCH functions in a text formula that is dynamic and will extract the text even if the source data changes
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:04:23

Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula

Excel Magic Trick 0:06:57

Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

Excel Magic Trick 0:05:58

Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?

Excel Magic Trick 0:04:59

Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters

Excel Magic Trick 0:02:49

Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39…

Excel Magic Trick 0:00:48

Excel Magic Trick

Split Cell | 0:01:37

Split Cell | Remove Text Before/After A Specific Character | Excel tricks | The Universal 360

Excel Magic Trick 0:02:40

Excel Magic Trick 1194: VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do?

Excel Magic Trick 0:05:08

Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

Excel Magic Trick 0:02:25

Excel Magic Trick 1188: SUMIFS with Wildcards to Do Approximate Criteria or “Fuzzy” Criteria

Excel Magic Trick 0:05:23

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTabl...

Excel quickly remove 0:00:59

Excel quickly remove only characters or only numbers or everything except text and numbers

Excel Magic Trick 0:09:53

Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel

Excel Magic Trick 0:09:47

Excel Magic Trick 1196: YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips…...

How to Remove 0:02:10

How to Remove Dashes in an Excel Program : Microsoft Excel Tips

How do I 0:00:40

How do I remove all text before/after a specific character without formula

Excel Magic Trick 0:08:22

Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter

Excel Magic Trick 0:07:08

Excel Magic Trick 1176: CONVERT Function to convert units in Excel (Excel CONVERT Joke at 05:27)

Excel Magic Trick 0:02:27

Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions

Remove all Content 0:02:02

Remove all Content in Parenthesis

Excel Magic Trick 0:07:45

Excel Magic Trick 1195: Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution?

Excel Magic Trick 0:03:33

Excel Magic Trick 1185: Calculate Standard Deviation from Frequency Distribution in Excel

Excel Magic Trick 0:08:32

Excel Magic Trick 1198: Median for Each Quarter Using AGGREGATE Function

extract text or 0:03:36

extract text or number after comma in excel

Комментарии
Автор

Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, LEFT SEARCH Functions
See how to take a list of menu items with unwanted text after the dash and remove the unwanted text using:
1. (00:08) Flash Fill (Excel 2013 only)
2. (01:01) Flash Fill and keyboard Ctrl + E (Excel 2013 only)
3. (01:24) Test To Columns
4. (02:09) LEFT and SEARCH functions in a text formula that is dynamic and will extract the text even if the source data changes

excelisfun
Автор

Best part of your videos... the sound effects!  Copy all the way down... tongue thwack.  Truly appreciate your videos!

mr.brownstone
Автор

Excel 2013 looks great but I am stuck with 2010 version.  I like it that way because I get to see all of you great formulas.  You are the MASTER and you get the 'point'.

robertlohman
Автор

Mike!!! You've done it again. Even though this video is quite old it was just what I was looking for. I admire your teaching style because you get straight to the point without all of the other fluff! Thanks once again!!!

anthonyverdin
Автор

This actually just saved my day (and my sanity). Thanks SO much!

slushroom
Автор

Hello Mike!

I hope you can help with this little problem. In your pivot advanced video you were talking about calculated fields in pivot which is pretty cool and looks simple to use until I want something more complex.

So the issue is that I'm not sure if calculated field works with SUMIF. I used one field for range, add my criteria like this: "*...*", and then another field from the pivot for sum range and it gives me an error message.

The internet suggests a workaround (insert a new column to your data) which I'm okay with of course, but I would be so happy if my idea works somehow. Nobody said that it can't be done, but it's probably impossible, I'm not sure.

Not even the biggest excel genius at my workplace knew any solution and if I keep watching your videos I might just become that person.

MrSarky