How do you separate words by words in a cell of excel?

Answer 1

1. Select a column of numeric data in a range of cells, or make sure that the active cell is in a table column containing numeric data.
   • To sort from low numbers to high numbers, click Sort Smallest to Largest.
   • To sort from high numbers to low numbers, click Sort Largest to Smallest.
2. On the Data tab, in the Sort & Filter group, do one of the following:

Answer 2

The way to split words in excel is to go to data and then text to columns, for more info on how to do this, refer to the link below by copying and pasting it into the URL or click on it when it's blue:

Answer 3

1) Select the column (or columns) you would like to move (click on the letter at the top of the column).

2) Cut the column (Press Ctrl + x, click the cut button on the Home tab of the Ribbon, or right-click and choose cut)

3) Select the cell where you want the new table to begin.

4) Right-click in the cell and select Paste Special (or on the Home tab of the Ribbon, click the Paste arrow to display the Paste Special option)

5) In the Paste Special dialog box, select Transpose and click OK.

After you have moved the contents from a column to a row, highlight the row and sort, as you normally would.