New Text Functions Released
Microsoft has released four awesome new text functions into Excel
News & insights for the everyday modeller
Microsoft has released four awesome new text functions into Excel
Splits text out across rows and/or columns
Returns text from a cell that occurs before a given delimiter
Returns text from a cell that occurs after a given delimiter
Compares values against a given expression and returns the corresponding result value
Concatenates values together from cells or ranges of cells
Returns one value for a TRUE result, and another for a FALSE result for multiple conditions
Find out more about how we support students sitting the Financial Modeling Institute exams.
I was preparing for some face to face training for a client recently and I was struck by two things when looking through their spreadsheets: