Excel MID function Example including SUBSTITUTE and FIND
Channel: Computer Tutoring
Date: 2018-01-31

Use the Excel MID Function to extract text that is between two commas. This example uses an address as an example in conjunction with the SUBSTITUTE function and FIND Function.
#computertutoring 

00:00 Introduction
00:15 MID function purpose – Extract Text
00:44 Type in address all in one cell
01:00 functions to extract a word from within two commas
02:12 How the MID function works
04:35 Use the Find function to find the beginning
06:36 Use the Substitute function to find the end
10:35 Going back to original MID function 
11:25 Consolidate the formula
14:38 How to evaluate your formula
16:14 Operator Preference – BODMAS
18:40 Delete helper cells
19:15 How to use the Trim function to deal with spaces
19:50 Summary


😊 Check out my website and social media to keep up to date - enjoy learning 😊

 📱 http://www.computertutoring.co.uk/ 📱 
📽 https://www.tiktok.com/@thecomptutor 📽 
👨‍👩‍👧‍👦 https://www.facebook.com/ComputerTutoring.co.uk/ 👨‍👩‍👧‍👦 
🦉 https://twitter.com/CT_Tutoring 🦉 
📷https://www.instagram.com/computer_tutoring/ 📷 
📌https://www.pinterest.co.uk/CT_Training/ 📌