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!
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!
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!
