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

Watch on YouTube

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