Excel Substring: What it Means and How to Use it скачать в хорошем качестве

Excel Substring: What it Means and How to Use it

In today's video, we'll show you how to extract substrings using functions in Excel. The functions we are looking at are LEFT, RIGHT, MID, and SEARCH. But we also have a bonus tip that uses the SUBSTITUTE function. Let's jump in! 👋 Hi! Was this video helpful? If so, consider buying us a coffee. We'd really appreciate it, and you'd be helping us grow the channel! 🥰 ☕️ Buy us a coffee: https://www.buymeacoffee.com/btpblog Thank you! ❤️ ************* 💻 Extra resources: LEFT Function: =LEFT(CELL or "text", number) LEFT Examples: =LEFT(A1, 2) =LEFT("mystring", 2) [ Returns "my" ] RIGHT Function: =RIGHT(CELL or "text", number) RIGHT Examples: =RIGHT(A1, 6) =RIGHT("mystring", 6) [ Returns "string" ] MID Function: =MID(CELL or "text", start position, end position) MID Examples: =MID(A1, 3, 3) =MID("mystring", 3, 3) [ Returns "str" ] 💬 Did you enjoy this video? Let us know all about it in the comments below! ✔️ Subscribe: Subscribe to Business Tech Planet using this link:    / @businesstechplanet   Thank you very much for stopping by, we have lots of other great videos that can help you in a huge assortment of tech-related ways! ************* 🛒 Support BTP with your M365 purchases: https://bit.ly/3ITCbEO ➡️ As full disclosure, Business Tech Planet uses affiliate links — such as the one above. Purchasing through these links gives Business Tech Planet a small commission at no extra cost to yourself, and it helps us continue to produce content for this channel. ************* 💯 Welcome to the official YouTube Channel of Business Tech Planet - We make business tech simple! On this Channel, we explain how technology works and how your business can use it in terms that anyone can understand, regardless of technical knowledge. The way we do that is by offering incredibly thorough and easy-to-follow video tutorials that anyone can understand. ➡️ Here we explain how you can safeguard your business as you begin using more future-proof cloud-based tech, from explaining how you can improve security and your organization's redundancy. We cater to audiences that may or may not be tech-savvy. The goal is to make sure our content is understandable to people from all walks of life as well as instructive on how to make the most of their business's technology. ➡️ We also operate a website that offers Tech Tips and guides related to issues people may have with Technology. The guides and tips we offer are done with the philosophy of providing excellent information for businesses regarding safety, future-proofing, and redundancies. ✅ Visit Business Tech Planet online: https://businesstechplanet.com/ So, if you are also passionate about making tech make sense, we upload video content frequently, and you should definitely subscribe to the channel and activation the bell icon to never miss a video! 🔔 ************* 🕐 Timestamps: 0:00 - Intro 0:34 - What is a substring? 1:17 - Get substrings using the LEFT function 2:07 - Get substrings using the RIGHT function 2:36 - Get substrings using the SEARCH and MID functions 4:12 - Bonus tip! 5:46 - Outro ************* #BusinessTechPlanet #excel #exceltips #exceltricks #substring #left #right #mid #search #substitute #function #functions #guide #howto #microsoft365 #office365