Join Dennis Taylor for an in-depth discussion in this video Convert text data to values, part of Excel 2016: Cleaning Up Your Data.
- [Narrator] In this chapter four workbook,…the first worksheet is called text to values.…Now, you might or might not be seeing…these green triangle indicators.…If you're not seeing them, you're not always…going to be seeing, also, the indicators…that might help you figure out what's going on.…So first of all, these green triangles are present.…When they are, and you click on a cell…that has a green triangle, or you highlight multiple cells,…you do get an indicator,…click the drop arrow, and you'll see an indicator.…Number stored as text.…
Now fortunately, there's a choice called convert to number,…we could convert these, just like that,…and of course, let me undo that,…and why not do them all?…When they're all highlighted though,…and one of the cells isn't of that format,…we don't see the indicator, so that might…throw you off a little bit.…If we highlight just the numbers here,…that have the triangles in them, in this column,…we see that indicator no matter how we scroll…up and down, we're going to be seeing that indicator there…
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