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

 

 

Example 2

 

Example 3


 

 

Example 4

  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail