Convert Text to Columns

  • Thread starter Thread starter Eán
  • Start date Start date
E

Eán

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 Data>Text 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
 
Back
Top