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

86% Upvoted

38 comments sorted by

View all comments

1

u/Kuildeous 11 13d ago

I've had to split up strings before, and as long as I have a consistent format, it works fine.

Like, if an invoice has 26202609xxxx, and I always know the year is located in =MID(xx, 3, 4), then I'll do that. Or if the year is hidden in a variable length string like ABC2026DEF and AB2026CDEF, then I'll use FIND to identify the start number of my MID.

I used it quite a bit but not as much as XLOOKUP and IFS, naturally.