How to Separate Text From Numbers in Excel. ... For example, if the data is in the first row, click on the second cell and look at the Formula Bar above the spreadsheet, ...