This post explains how to use the new Excel TEXTSPLIT function. TEXTSPLIT() is a Text function in Excel. The purpose of this function is to split a given text string on the basis of one or more ...

Find and Replace is a useful feature in the Office suite programs which allows replacing an existing text with a new text. However, it can also be used to find and replace the color of the text. You ...

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 ...

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more. Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating ...