|Connect us with


How to use Text-to-Column in Excel?

Text-to-Column | Shortcut | Examples | Delimiter

Text to Columns in Excel: if you want to separate one cell content into separate columns in Excel, you can use the 'Convert Text to Columns Wizard'. this option is available in Data Tools in the Data tab. Text-to-Column is an amazing built-in tool in Excel. Using this we can separate texts into columns with characters like(/,-,space, and user input).

To access Text to Column shortcut in Excel, use: ALT + A + E

Examples:

In this below example, we have a list of state names and we need to separate these state names into name and state.

Text to Columns Example in Excel

To separate name and state from this, follow the below steps.

1. Select the range you want to separate. in this example A1:A5.

2. Go to Data Tab, then click on Text to Columns.

Text to Columns

3. You will get below dialog box, there select Delimited and click Next.

Convert Text to Column Wizard Step 1

4. Uncheck all check boxes in Delimiters and select the Space check box. because in this example we want to separate names with Space as Delimiter.

5. Click Next and give Finish.

Convert Text to Column Wizard Step 2

Now the Name and States are separated using Space Delimiter. you can also use Tab, Comma, Semicolon, and Other option to separate cell texts into columns.

Result:

Text to Columns Result

Custom Delimiters Example:

Let's take one more example, here we have State names with Pincodes. now we need to separate Pincodes from State names.

Text to Columns Example-2

To Separate this, here we need to use Delimiter as (-) instead of Space (which we used in the previous example).

Text to Columns Delimeter Example.

in the same way, you can use custom Delimiter to separate Texts to Columns. and the Result is,

Text to Columns Example Result

You May Also Like the Following Excel Tutorials:

IF YOU LIKE OUR EXCEL TUTORIALS PLEASE DON'T FORGET TO SHARE

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.


To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments



Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.