Join Dennis Taylor for an in-depth discussion in this video Converting dates with text functions, part of Cleaning Up Your Excel 2010 Data.
There are many different ways in which you can enter a date data into an Excel worksheet;…however, a lot of different layouts don't lend themselves to working with…Excel dates efficiently.…To work with dates efficiently in Excel, they must be considered values, so that…we can work with them computationally.…Date, the way we see it in column A and in column C isn't really set up…properly. But if we've got a ton of entries like this, we want to be able to…convert them into actual dates, and usually this takes a separate column.…
Now, a function you wouldn't necessarily know much about, but relatively easy to…use, is a function called date, and this function needs a year, month and day.…Now the date in Column A doesn't have any days associated with it, so we'll just…use the first day of the month.…So what can we do with this information?…From the right-hand side of each of those entries there, the four rightmost…characters consist of the year. So here's a function called right, and its sole…purpose is to pull data out of the right-hand side of these cells.…
- 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.