I want to filter on cells in the colum which starts from a alphabet.

[waqar1239]

Hello Team,
Could someone advise me how I can filter only cells which starts from alphabet
V345
T039
0231
M444
0311
Q001
I would like to see only which starts from alphabet. Please advise me

 

[CyrusTheVirus]

Add a column to the right and add the below formula, then filter by that column. Reach out with questions.

Cell B2:

=IF(ISNUMBER(--A2),"No","Yes")

Data should look like the below.

Data	Starts With Letter?
V345	Yes
T039	Yes
0231	No
M444	Yes
0311	No
Q001	Yes

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[waqar1239]

Thanks a lot for your support on this

Cheers
Waqar