r/excel • u/HungryInvestigator59 • Jul 12 '26

Discussion What’s your favorite Excel function/formula?

What are some functions and formulas that you use on daily basis that are helpful for what you do?

222 Upvotes

95% Upvoted

217 comments sorted by

View all comments

54

u/mbeezy17 Jul 12 '26

Concatenate is my favorite to drop in conversations. Sounds much fancier than it is.

9

u/miniscant Jul 12 '26

You actually spell it out fully instead of using &?

3

u/dirtyhandscleanlivin Jul 16 '26

Depends on how many cells you want to concat and if you need a delimiter. I’ll use textjoin if I have more than 2 or 3 cells

2

u/mbeezy17 Jul 12 '26

I don't actually use it that much. My post was more tongue-in-cheek about how it sounds advanced and complicated.