Power Query to Import CSV using Text Filter

[brawnystaff]

I am looking to selectively import a large CSV file into Excel with Power Query. Basically, I want to import by filtering the column "Last_Name" where the first character starts with the letters A through M. I see the option for "begins with" under Text Filters, but how do I specify the range "A" through "M". Below is the M code it is showing for filtering by first letter A..

 #"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.StartsWith([Last_Name], "A"))

 

[billszysz]

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.Upper(Text.Start([Last_Name], 1)) <= "M")

 

[brawnystaff]

Thanks billszysz. That worked.