TechRepublic

How to use the new TEXTAFTER() and TEXTBEFORE() functions in Microsoft Excel

Microsoft Excel’s new text functions make working with strings a breeze. A common task is to parse or find characters within a delimited string in Microsoft Excel. Fortunately, Excel has several ...
TechRepublic

How to use the new TEXTSPLIT() function in Microsoft Excel

How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a character ...
YouTube on MSN

Scan function in Excel (one of the hardest to learn)

Learn how to effectively use the SCAN function in Excel to enhance your formula-building skills. This tutorial presents four ...