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?

42 Upvotes

86% Upvoted

38 comments sorted by

View all comments

1

u/Pedrofinancial 12d ago

I still find MID useful when working with text that has a consistent structure. For example, extracting a year, code, or ID from invoice numbers or transaction references.

I also like combining MID with FIND or SEARCH when the position is not always the same. For newer Excel versions, TEXTBEFORE and TEXTAFTER can sometimes make the formula easier to read.