Gary, Jamie, Monish and Michael all check in with ideas on why to use the Split command. Episode 1101 is a follow up to last Wednesday's podcast 1098.
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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Filters
Show only:
Loading…
Christina asks how to make sure that the students in her class stay within a tiny range of the spreadsheet. Episode 509 discusses two methods to solve this problem.
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!
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 Georges 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!
Your crazy software exported a file where the date column has the not-so-useful values like Jan, Feb, and Dec in a column. Episode 507 looks at a function to convert those values to real dates.
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!
Christina asks how to create a gradebook in Excel. Episode 506 shows off how to create absolute references and also the obscure TRUE version of the VLOOKUP function. Everyone teachers and non-teachers should check out the VLOOKUP in this episode.
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!
Thanks to many viewers who wrote in after Episode 497, there is a much easier way to count the number of cells that contain a certain substring. In Episode 505, learn how to use the wildcard options in COUNTIF and AutoFilter.
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!
If you use the shapes on the drawing toolbar such as the rectangle, oval, and arrow, you will discover that the shapes do not stay connected when you move them. Rather than using the arrow, Episode 504 shows you how to connect the shapes using a connector that will always stay attached to the shapes.
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!
Say that you have a pivot table with region and product in the row area. If you would like a blank row between each region, or even a page break between each region, change the Layout properties for the field. Episode 503 shows you how.
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!
