Feed it a cell reference or text string, and Excel will handle the rest. Let’s say you're migrating data from a database where names were entered in all caps and want them in a friendlier format.

A Convert Text to Columns Wizard dialog box will open. Select Delimited, then click Next. Select the Delimiters for your data; In this tutorial, we selected Space. Click Next.

To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.