Often known as the universal data munging tool, Excel is trying out new options for processing messy text as well as entering it more quickly and accurately in the first place. One of the reasons ...

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

Computer programmers often use parsing programs to convert text into formats that other applications can use. Parsers split items in a text string into separate fields. If, for example, you have a ...

Join in on the Excel fun.

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Is it possible to ...

The smartest thing Excel does happens in places you can't see.