Excel - Converting Text Numbers to Real Numbers Using Minus Minus - Episode 1210
477 views · Published 4 June 2010 · 1:43 · Indexed 12 November 2026
Channel: MrExcel.com · 2010 · Education
Microsoft Excel Tutorial: Denise from Orlando checks in with a cool trick for converting text to numbers using the minus minus trick. Episode 1210 shows you how. Learn Excel 97-2007 from MrExcel! Welcome back to another episode of the MrExcel podcast, where we bring you the latest and greatest tips and tricks for Excel. In this episode, we'll be discussing a question from one of our listeners, Denise, who attended our recent seminar in Orlando, Florida. She had a great question about extracting numbers from a part number that has a letter and three digits. We'll be sharing her solution and how it can save you time and effort in your data analysis. Denise's question was how to get just the number portion of a part number in column A. While the =RIGHT formula can easily do this, it converts the numbers to text, which can cause issues when using functions like VLOOKUP. Denise's solution was to use a double negative sign (--), which converts the text to a number without the need for any additional steps. This is a great shortcut that can save you time and hassle when working with large datasets. We also want to take a moment to thank all our listeners and viewers in the United States, as we approach a long holiday weekend. We hope you have a great time with your loved ones and enjoy some well-deserved time off. And for those of you who are not in the US, we hope you have a great week ahead. Don't forget to tune in for our next episode, where we'll be sharing more valuable tips and tricks to help you excel in Excel. And as always, thank you for watching the MrExcel podcast, brought to you by MrExcel.com. See you next time!" Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Question from Denise about extracting numbers from text (00:24) Using =RIGHT function to extract numbers (00:34) Need to convert numbers to text for VLOOKUP (00:44) Paste Special Values and Data, Text to Columns method (00:54) Denise's alternative method using math to convert text to numbers (01:10) Quick and easy way to convert text to numbers (01:27) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Central Florida IMA seminar Converting text to numbers Data Text to Columns Excel master-pin Excel tips Holiday weekend Netcast from MrExcel Orlando Paste Special Values VLOOKUP Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152823/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920