How can I write a Google Sheets query function that will sort a list that has a Letter and number pr-CodePudding

Home > OS > How can I write a Google Sheets query function that will sort a list that has a Letter and number pr

How can I write a Google Sheets query function that will sort a list that has a Letter and number pr

Time：02-02

In google sheets, I have a ton of data that needs to be sorted like this: P1, P2, P3, etc using a QUERY function. when I do an "ORDER BY" clause in my QUERY formula, it returns the list incorrectly putting P10 right after P1 as shown below

I got the list returned like this...

P1 P10 P2 P3 etc.

Page link：https//www.codepudding.com/os/690558.html

Prev:An ARRAYFORMULA formula that adds but resets the result before a certain number is exceeded

Next:Google Sheet formula to check all rows and bring a third value

Tags：

sortinggoogle-sheetssql-order-by

Links：
CodePudding