'Filter data starts with character - Google Sheets

I have large set of data, and I want to filter the data which only start with certain character inside Query.

For example:-

AVTD1X4K1V0R01IA
AVTD1X4K1V0RXXF1
AVTD1X4K1V0RXXFA
AVTDMAIN1V0R03IA
AVTDMAIN1V0RXXFA
AWEWE23232323232
BLIVSE20122014X1
CA100U50VXSRCCCF
CA330U50VXSRCBCF
CA47UX63VXSRBBCX

In that data If I want to get starting with 'A' codes.

Thanks in advance

google-sheets

Solution 1:^[1]

Try

=query(A:A,"select A where A like 'A%' ")

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Mike Steelson

'Filter data starts with character - Google Sheets

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]