Excel 2007: LEFT And SEARCH Functions

431 views · Published 14 July 2017 · 10:04 · Indexed 31 October 2026

Channel: Kirt Kershaw · 2017 · Education

Watch on YouTube

Excel 2007 tutorial on LEFT function that returns the number of characters at the start, or "left" side of the cell, and the SEARCH function is used the find the text like a space delimiter with a cell, and when these two are combined Excel will count from "left" to right the minimum number specified in the "search", up unto and including the delimiter, as you'll see in this Excel 2007 training video on LEFT and SEARCH 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

More from this channel