I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.
Note: Please take the material offered here as an intellectual challenge. You should be aware of the fact that Excel © is a historically grown application. This means it is providing a historically grown (better: kept) functionality (read: behaviour). Of course it is good to know all functions because they are mostly the fastest solution (in terms of calculation speed) if you only need their limited functionality. But the functions shown here are quite limited. In many cases I needed a more flexible or enhanced functionality. Which I happened to find with other functions or approaches. So this is meant by obsolete.
I think obsolete functions are:
In my opinion semi-obsolete functions are:
Some fun function replacements:
LEFT(A1,n) = MID(A1,1,n)
RIGHT(A1,n) = MID(A1,LEN(A1)-n+1)
MID(A1,m,n) = RIGHT(LEFT(A1,m+n-1),n)