deleting values out of a columns

[Nils_Junker]

Hi there,

is there a possibility to automatically delet certain values out of a column.
So in my example i got the following data:

F-Code

F000034602

F000034461

F000034603

7517701​

F000044070

F000117104

F000115754

F000115752

F000035619

F000035621

F000034003

F000033881

F000034127

F000054986

7431601​

7432001​

F000117098

F000047720

F000047719

7624301​

F000103718

SO would it be possible to delete all the values which doesn't contain an "F"
Selecting the values by their own isn't an option.
Best it would be without the use of VBA.

Looking forward to hearing from u.

 

[Joe4]

In your example, if you just want to return the values that start with an "F", you can use the FILTER function, i.e.

Formula in cell C2:

=FILTER(A2:A22,LEFT(A2:A22,1)="F")