Use of Text to Columns Formula

Last updated at Dec. 13, 2024 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

Go Ad-free
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.