Technique 1
- Press F5, or choose Edit, Go To…;
- In the Go To dialog box, click Special.
- In the Go To Special dialog box, select Constants.
- Click OK.
Technique 2 - Conditional
Formatting
- Select the data area.
- From the Format menu, select Conditional Formatting.
- In Condition 1, select Formula Is.
- In the Formula Box, enter the formula =Istext(A1).
- Click Format..., choose any format from the Format Cells dialog box, and click OK.
- Click OK.
Screenshot // Selecting cells that only contain Text in Microsoft Excel