Splitting Names - 1145 - Learn Excel from MrExcel Podcast

Diane from Michigan wants to split a column of names into two columns. Episode 1145 shows two approaches and the problems with each.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 753 - Text Date/Time

When Romas sent in the question for podcast 751, I couldn't tell from the screenshot if his data actually was date/time or text that looked like a date/time. In Episode 753, I take a look at how to tell if the cell contains a date or something that looks like a date. You will also see how to use the TEXT, LEFT, MID, DATE functions to convert the text date/time to a real date.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 508 - Add a Dash

If you need to spice up a column in your report, Episode 508 will teach you how to add a dash to a column. Viewer George writes in to say that his vendor needs the orders transmitted with a dash in the middle of the part number, but George’s data does not have the dash. Learn how to use MID and LEFT and concatenation to put a dash in the middle.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 159 - Get characters up to the Dash

Episode 159 - Get characters up to the Dash
The Left, Mid, Right functions are great, but what if you need to grab a variable number of characters from the left portion of the cell? For example, you need all of the characters up until the first dash? In this case, you will have to use =FIND() to find the position number of the dash. This episode also demonstrates a cool trick for combining functions. When you need to create a complex formula, you might build one part of the formula in one column and the rest of the formula in a second column. This episode shows a unique trick for copying the function from the first column and pasting it into the formula bar of the second function. Episode 159 shows you how.

This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!