Check if a cell contains text (case | Excel FIND text
Letssayyouwanttoensurethatacolumncontainstext,notnumbers.Or,perhapsyouwanttofindallordersthatcorrespondtoaspecific salesperson.Ifyouhavenoconcernforupper-orlowercasetext,thereareseveralwaystocheckifacellcontainstext. Youcanalsouseafiltertofindtext.Formoreinformation,seeFilterdata[1]. Findcellsthatcontaintext Followthesestepstolocatecellscontainingspecifictext: Selecttherangeofcellsthatyouwanttosearch. Tosearchtheentireworksheet,clickanycell. OntheH...
Lets say you want to ensure that a column contains text, not numbers. Or, perhapsyou want to find all orders that correspond to a specific salesperson. If you have no concern for upper- or lowercase text, there are several ways to check if a cell contains text.
You can also use a filter to find text. For more information, see Filter data[1].
Find cells that contain textFollow these steps to locate cells containing specific text:
Select the range of cells that you want to search.
To search the entire worksheet, click any cell.
On the Home tab, in the Editing group, click Find & Select, and then click Find.
In the Find what box, enter the text—or numbers—that you need to find. Or, choose a recent search from the Find what drop-down bo...