Hosted on MSN

Old Excel functions you should stop using (and what to replace them with)

Excel is packed with functions, but if you're still relying on VLOOKUP, nested IF statements, or CONCATENATE, you're making your spreadsheets harder to manage than they need to be. Microsoft has newer ...
Hosted on MSN

Excel’s INFO and CELL functions tell you what’s happening under the hood

Excel has plenty of built-in functions for calculations, but some of the most useful ones don't crunch numbers at all—they reveal information about your spreadsheet itself. The INFO and CELL functions ...
JournalofAccountancy

Using Excel’s TEXTBEFORE AND TEXTAFTER functions to easily tame messy data

How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER ... The text argument references the text or cell where you’re searching. The delimiter is the marker ...