Join Dennis Taylor for an in-depth discussion in this video Remove trailing minus signs while converting data to negative, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] On this worksheet called trailing minus,…that describes exactly what we are seeing in column A…next to some of these numbers.…In other counting systems,…you may be getting information from them…and you might see a trailing minus, which means negative.…Can we deal with these directly?…Let's zoom in a little bit and try multiplying one…of these numbers or adding to it.…What happens if, for example, we take this entry plus one.…What do we get?…Value, that's just not working…the way we would want it to.…So, can't do that.…What can we do?…Well, one obscure way and I won't complete it,…would be to use an if function.…
It would start off something like this, if.…And we need to use text functions…to see if the right most character out of here…is equal to a minus.…And then proceed from there.…I'm not going to finish it, it would take a while,…but that's one possible approach.…But there's a more direct way, but not obvious.…Relatively easy too.…Let's select column A and then…go to the data tab in the ribbon…and use the feature called text to columns.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes