Excel MID function Example including SUBSTITUTE and FIND
5 هزار بار بازدید -
7 سال پیش
-
Use the Excel MID Function
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/ 📱
📽 TikTok: thecomptutor 📽
👨👩👧👦 Facebook: ComputerTutoring.co.uk 👨👩👧👦
🦉 Twitter: CT_Tutoring 🦉
📷Instagram: computer_tutoring 📷
📌https://www.pinterest.co.uk/CT_Training/ 📌
#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/ 📱
📽 TikTok: thecomptutor 📽
👨👩👧👦 Facebook: ComputerTutoring.co.uk 👨👩👧👦
🦉 Twitter: CT_Tutoring 🦉
📷Instagram: computer_tutoring 📷
📌https://www.pinterest.co.uk/CT_Training/ 📌
7 سال پیش
در تاریخ 1396/11/11 منتشر شده
است.
5,098
بـار بازدید شده