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