How To Convert Text to Columns In Excel

  • Lets start with example of US states Population. As we see data below has State and Population separated by space. But in each row both fields are part of same column I



  • Select the text in column I, either Click on top of column I or drag to select the whole text...



  • To Convert above text in to two separate columns I and J. Look for option Text to Columns under the Top menu "Data" as shown below...


  • Now follow the rest of steps as shown below...


  • Select option "Delimited" and click "Next"



  • Select the option "Space" and click "Finish"



  • You should see following output...