Excel 2007: RIGHT, SEARCH And LEN FUNCTIONS
128 views · Published 14 July 2017 · 9:58 · Indexed 21 September 2026
Channel: Kirt Kershaw · 2017 · Education
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
-
1:29
39 Medical Practice Task Scheduler - Medical Billing
-
10:47
86 Patient Billing - Medical Billing
-
3:47
Excel 2007: AutoFill
-
1:13
Excel 2003: Split Worksheet or Split Spreadsheet into 2 or 4 Windows
-
5:20
Excel 2003: Protect Worksheets Allowing Certain Users Make Edits
-
8:58
Excel 2010: Move, Cut, Copy And Paste Data
-
3:45
Excel 2010: Clipboard
-
2:38
Excel 2016: Conditional Formatting Manager