Episode # 159 - Get characters up to the Dash

Sponsored by

Learn Excel from MrExcel

Check out this book for more tips
similar to this lesson!

Tuesday, January 03, 2006

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.

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 3 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: Formulas

More Excel Video Lessons

If you like this video, there are hundreds of 2-5 minute videos available here: