Excel 2007: RIGHT, SEARCH And LEN FUNCTIONS

128 views · Published 14 July 2017 · 9:58 · Indexed 21 September 2026

Channel: Kirt Kershaw · 2017 · Education

Watch on YouTube

Excel 2007 tutorial on RIGHT function that returns the number of characters beginning at the end, or "right" side of the cell, and the SEARCH function is used the find the text like a space delimiter with a cell, and the LEN function is used to count each characters in the cell, and when these three are combined, Excel will return the exact number of characters from the right most part of the cell, as you'll see in this Excel 2007 training video on RIGHT, SEARCH and LEN functions.

All 119 of my Excel 2007 training videos contain everything you need to help pass both the Microsoft Office Excel 2007 Core (77-602), and Expert (77-851) exams and become certified!

PATREON: Kirt Kershaw & Dream Force, LLC invite you to subscribe for the $2 monthly option which includes ALL Microsoft Office training tutorials 2016, 2013, 2010 and 2007.  New videos will be constantly uploaded to Patreon so you will get new content.  Visit and sign up at: https://www.patreon.com/KirtKershaw 

DVD & DOWNLOAD AVAILABLE: 
https://www.DreamForce.us

SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
http://www.youtube.com/subscription_center?add_user=videotrainingpro

LET'S CONNECT!
-- http://www.facebook.com/KirtKershaw 
 
-- http://www.linkedin.com/in/kirt-kershaw-33874410
-- https://www.instagram.com/kirtkershaw

More from this channel