Select the cell or cells with data that you want to be split into columns. 2. Select Split text to columns from the Data menu. 3. In the Separator dialog box, select space.