# Videos tagged with MrExcel

## Learn Excel Episode 1102: Split Vertically at 20's

Posted in Companies, Podcasts

Dak asks how to take a long cell entry and to split it into 20 character entries going down a column without using wrap text. Episode 1102 shows a couple of ways to solve the problem.

## Learn Excel Episode 1101: Split Ideas

Posted in Companies, Podcasts

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.

## Learn Excel Episode 1100: Dueling : CountIf Range

Posted in Companies, Podcasts

DRG asks how to use COUNTIF to find records that match a range. Unfortunately, it can not be done with COUNTIF. In Episode 1100, Bill and Mike compare six solutions.

## Learn Excel Episode 1099: First:Last!

Posted in Companies, Podcasts

Pablo sends in a cool tip for using Spearing Formulas. Episode 1099 shows you how.

## Learn Excel Episode 1098: Split?

Posted in Companies, Podcasts

## Learn Excel Episode 1097: Removing Name

Posted in Companies, Podcasts

Shift-Del sends in some alternative formulas to solve the problem from episode 1043. To see uses of SUBSTITUTE and REPLACE in Excel, check out Episode 1097.

## Learn Excel Episode 1096: VBA Sheet Name

Posted in Companies, Podcasts

Your recorded macros might not work if someone renames a worksheet. Rather than use the worksheet name, use the code name for the worksheet. This name can never be changed and is more reliable. Episode 1096 shows you how.

## Learn Excel Episode 1095: Dueling: Random Date

Posted in Companies, Podcasts

Mike and Bill offer different ways of generating a random date between two dates. Episode 1095 shows you how.

## Learn Excel Episode 1094: Automatic Freeze Panes

Posted in Companies, Podcasts

Excel 2007 offers a cool trick to replace Freeze Panes. Episode 1094 shows you how.

## Learn Excel Episode 1093: Revenue Bridge Chart

Posted in Companies, Podcasts

Mike from Arizona asks how to create a revenue bridge chart. This is similar to a waterfall chart, except some of the points are negative. Episode 1093 will show you how to create this chart.