Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, ...

or the Excel mobile app. Before I show you some examples of each function in action, here are their syntaxes. The TRANSLATE function has three arguments: =TRANSLATE( a b c where If you don't place ...