Question

How to find when a character ends and number starts in excel?

Answer 1

Select a blank cell (cell B2) in a help column for showing the result, enter formula=IF(LEFT(TRIM(A2),1)="s","OK","Not OK") into the Formula Bar, and then press the Enter key. See screenshot:



2. Keep selecting cell B2, and drag the Fill Handle down until all cells are checked.