How to use TRIM with QUERY function in Google Sheet?

media10k 0
Viewed 18

I want to TRIM the E column in the below query function in Google Sheets. I am not able to find the solution. Can you please help me with this?

=QUERY(E1:K50,"SELECT* ORDER BY K DESC")

Thanks in advance. Regards, Vineet

google-sheets-formula google-sheets
1 Answers

try:

=ARRAYFORMULA(QUERY({TRIM(E1:E50), F1:K50}, "order by Col7 desc", ))
player00
Related