MID Excel Function (Formula, Example) | How to Use MID Function?
In this video on MID Excel Function, here we discuss the MID formula in excel and how to use MID excel function along with example.
𝐌𝐈𝐃 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
-----------------------------------------
MID function is a text function used in excel to extract the substring from the center of a string.
MID in excel returns a certain number of characters or a substring based on the starting point and the number of characters you specify.
𝐌𝐈𝐃 𝐄𝐱𝐜𝐞𝐥 𝐅𝐨𝐫𝐦𝐮𝐥𝐚
--------------------------------------
= MID (text, start_num, num_chars)
𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬
--------------------------
text = It's the text you want the substring to extract.
start_num = the starting position of the substring.
num_chars = the numbers of characters of the substring.
𝐓𝐡𝐢𝐧𝐠𝐬 𝐭𝐨 𝐑𝐞𝐦𝐞𝐦𝐛𝐞𝐫 𝐰𝐡𝐢𝐥𝐞 𝐮𝐬𝐢𝐧𝐠 𝐌𝐈𝐃 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
--------------------------------------------------------------------------------------------------
If the start num is larger than the string length, the Excel MID function returns empty text.
To know more about 𝐌𝐈𝐃 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- https://www.wallstreetmojo.com/mid-ex...
Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe - / @wallstreetmojo
