Join Dennis Taylor for an in-depth discussion in this video Converting text data to values , part of Cleaning Up Your Excel 2010 Data.
Sometimes you encounter columns of numbers that have been formatted as text.…Now, usually that's done not necessarily directly, but sometimes by mistake. And…in some respects, it's not a major issue, but at other times, it is.…First of all, rarely do you see numbers aligned on the left-hand side.…So in Column B here--we can certainly do this with Column E as well too--perhaps we'll just…go the Home tab and right-align.…Now that doesn't mean that they are numbers necessarily. And what you run into…sometimes is suppose these represent thousands, or suppose they represent dollars.…
What if we use one of the symbols in the Number group on the Home tab in the Ribbon?…I want to turn these into dollars, or display them with dollars.…It's shifted the data over a little bit, but it didn't apply the dollar signs.…And how about comma here?…It's not doing anything either, is it, other than shifting the data over here?…So what's happening, how can we deal with this?…Well, one way, and it seems like a strange thing to do, but all we need to do is…
- Moving or inserting rows and columns of data with a simple drag
- Using Text to Columns
- Harnessing the Find and Replace command to replace data at the character level
- Dealing with special characters and wildcards during search
- Converting dates with text functions
- Converting text data to values/numbers
- Checking and correcting spelling mistakes
- Splitting data into multiple columns via the Text to Columns feature
- Combining data from different columns via concatenation
Skill Level Intermediate
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.