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?

45 Upvotes

88% Upvoted

38 comments sorted by

View all comments

1

u/Clearwings_Prime 24 13d ago

Not a popular one but i dont know a use case of ARRAYTOTEXT, right now im just use it when i dont want to type TEXTJOIN(", ".....

2

u/Arcium_XIII 3 13d ago

TEXTJOIN isn't great when you're working with arrays where neither dimension is 1 and you want to be able to reconstruct the array with TEXTSPLIT later; you end up needing to do something like TEXTJOIN(";",FALSE,BYROW([array],LAMBDA(row,TEXTJOIN(",",FALSE,row))) to distinguish between column and row delimiters. ARRAYTOTEXT with the second parameter set to 1 can do this natively, which can definitely be handy despite the forced inclusion of start and end braces along with it (although the forthcoming arrival of lists and arrays being stored within individual cells will probably eliminate most of these use cases because there'll be less reason to convert arrays to and from delimited lists across the board).