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.

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Data[/TD]
[TD="width: 64"]Starts With Letter?[/TD]
[/TR]
[TR]
[TD="class: xl63"]V345[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD="class: xl63"]T039[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD="class: xl63"]0231[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD="class: xl63"]M444[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD="class: xl63"]0311[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD="class: xl63"]Q001[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

 

[waqar1239]

Thanks a lot for your support on this

Cheers
Waqar