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

Many thanks

--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