Another Minus Minus - Episode 1210

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jun 4, 2010.
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!
maxresdefault.jpg


Transcript of the video:
The MrExcel podcast is brought to you by “Easy-XL”!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Oh, I'm back from Central Florida, the Central Florida IMA seminar down there in Orlando.
What a great crowd, got a lot of great tips I'm going to share, and some questions and things like that.
Denise checked in with this great, great question.
We have a part number over there in column A, has one letter and three digits, and we want to get just the number portion of that.
So, of course, everyone knows this, this is =RIGHT of this, ,3 , double click to copy that down.
But, if we're going to do VLOOKUP or anything like that, you'll notice that those are text now, they're not numbers, and if we really need to convert those to numbers, what can you do?
You could Paste Special Values, and then use Data, Text to Columns.
But Denise had a better way to go.
Instead of doing =RIGHT, you put --, when you do some sort of a math to text that looks like a number, it will convert it.
So the first - makes it -114, second – converts back to 114.
Great way to very, very quickly change that around.
So there you go, thanks to Denise from Orlando, she was thrilled to get an Excel master-pin at the seminar for that idea.
Hey, for all the folks in the United States, it's a long holiday weekend, enjoy your Monday off, picnics and whatnot, hopefully we'll have great weather for that.
We’ll see you next time for another netcast from MrExcel!
 

Forum statistics

Threads
1,213,537
Messages
6,114,216
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top