ExcelBanter - Convert Text to Columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Convert Text to Columns (https://www.excelbanter.com/excel-worksheet-functions/246810-convert-text-columns.html)

Eán[_2_]

Convert Text to Columns

I have 2000+ rows of data is there anyway I can convert everything in one go?

Many thanks

Jacob Skaria

Convert Text to Columns

--Select the range/column needs to be changed.
--From menu DataText to Columns will populate the 'Convert Text to Columns
Wizard'
--By default the selection is 'Delimited'.
--Keep the selection and hit 'Next'.
--From the Step2 of the Wizard from the options select the delimiter or
specify in other and hit Next.
--Hit Finish

If this post helps click Yes
---------------
Jacob Skaria

"Eán" wrote:

I have 2000+ rows of data is there anyway I can convert everything in one go?

Many thanks

All times are GMT +1. The time now is 05:25 PM.