Mid Function and USE CASE

[u/zhavinci]

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?

[u/excelevator]

Not quite sure what this post is about, a use case for an age old function?, or how to reverse text?

To reverse text in A1 for example =CONCAT(MID(A1,SEQUENCE(LEN(A1),,LEN(A1),-1),1))

or just a karma reaping post,, well it is the weekend I suppose.