How to use Text to Columns in Excel?

Text To Column option in excel is available in the Data menu tab under the Data Tools section, which is used for separating text available in a cell or column to the columns by splitting them with different criteria. Mostly this process is called the delimiting process, where we split or separate the text into the column with spaces, commas, any word, or else we can use a fixed-width option by which text will be placed into cells of the same row from the point we want to break it.

Following are the basic steps for Text to Columns:

  1. Select the range with full names.

  2. On the Data tab, in the Data Tools group, click Text to Columns.

  3. Choose Delimited and click Next.

  4. Clear all the checkboxes under Delimiters except for the Comma and Space check box.

  5. Click Finish.

There are two separate features of Text to Column:

  1. Delimited: This feature splits the text, which is being joined by characters, Commas, Tabs, Spaces, Semicolons or any other character such as a hyphen (-).

  2. Fixed Width: This feature splits the text which is being joined with spaces with some certain width.