- Aug 9, 2012
- Office Version
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"))