This post will show you how to remove the first or last few characters or certain position characters from the text in Microsoft Excel.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

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.

Have you played with the "Text to Columns" function on the Data menu/tab yet? It's similar but not quite identical to the File Open text importer.