How to use Excel MID Function to Extract Text

preview_player
Показать описание
This video is about how to extract part of the text that is in the middle of a longer text. Use the Excel built-in MID function to do this in seconds.

👇SUBSCRIBE

00:00:18 - Why Start a Channel
00:02:59 - What is my Channel About
00:03:54 - How to Get Started

Do you have more to add? Let me know how you liked the video or if I need anything corrected in the comments below.

#contentinsider #youtuber #smallyoutuber #smallytchannel
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

TECH GEAR I USE DAILY

OTHER COURSES I CURRENTLY TEACH

Let's chat
#CommisionsEarned
As an Amazon Associate I earn from qualifying purchases.
Рекомендации по теме
Комментарии
Автор

Great video. I never knew how useful the MID function was until I started to have to work with data from weird or old, legacy systems. They had dates that weren't like 9/17/2017 or similar. Instead they had dates as #Source#9, 2018March03day30Brand. Using a series of quick MID functions makes it simple to get out the pieces I needed (year, date and month) and then I used the date function (DATE(Year, Month, Day) to bring it back together in a separate column. :)

techknowhow