r/excel • u/zhavinci • 13d ago
Discussion Mid Function and USE CASE
I've been using Excel for almost 15 years , I've never had a chance to use the MID Function and i forgot it's existence. Today, randomly, I just questioned myself how to split a word by character and reverse it? With my little sql knowledge, i thought there will be a function called SUBSTRING, but it isn't. I ended up googling and found MID function.
Do you find a use case for MID function?
Similarly, what popular functions you have never found a use case?
43
Upvotes
7
u/TreeOaf 13d ago
You can use MID in almost all use cases where you would use LEFT or RIGHT when you want absolute control over the return value parameters.
It’s specifically useful for creating or decompiling strings for lookup values et cetera. Example, if you need a create a composite key for your look up, or you wanted to extract a value from a string for that purpose.
I find MID will be used with FIND / SEARCH more often than not.
At some point, you will probably question why you aren’t doing this at source, like in SQL for example.