How to Convert Excel to Text & Set Column Width. Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column. Excel's myriad formatting tools let you add colors, ...

Follow the steps below to convert text to columns in Excel: Launch Excel. Enter some data into a single cell, for example, the first name and last name of people.

If you want to parse strings such as "First Last" into separate columns, you don't need to use fancy formulas. Excel has a tool that makes the job a snap. In “Save time by using Excel’s Left ...