Use of Text to Columns Formula

Last updated at August 14, 2026 by

It is used to break data from one column to another column

 

How to do?

Select Whole column which needs to be broken

Data...>Text to Columns.,,>Select Delimited/Fixed width

 

Difference between

CONCATENATE TEXT TO COLUMNS
It is used to Combine 2 or more cells

It is used to break 2 or more  cells

Formula of Concatenate

=Concatenate(First Value,Second Value)

 

Procedure

Select Whole column which needs to be broken

Data...>Text to Columns.,,>Select Delimited/Fixed width

 

 

Example 1

Use of Text to Columns Formula - Text to Columns

Download Excel File And Try

 

Text to Columns.xlsx
 
 
 
 

Example 2

 

Example 3


 

 

Example 4

Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.