CODEWITHSUNDEEP
sortinggoogle-sheetsfilterstring-formattingnumber-formatting
Øyvind L. Runestad
Øyvind L. Runestad

Reputation: 61

Google Sheet filter-function not working as sorter

I have a Google Sheet with many numbers from 100-845. Some of them have either "pt" or "A/B/C" behind them, which makes filter putting them at the bottom of the sorting A-Z. Any quick fix you guys know of?

To make it easier to understand; in cell A2:A745 I have numbers as this in each row, which I want to sort:

100
101pt
101pt
102A
102B
103
104
...

I look forward to your replies.

Upvotes: 1

Views: 3891

Answers (2)

player0
player0

Reputation: 1

select column and convert it to Plain text

0

then sort it with A-Z

0

Upvotes: 1

Tom Sharpe
Tom Sharpe

Reputation: 34245

If they are all 3-digit numbers, you should be able to do this:

=sort(filter(A:A,A:A<>"")&"",1,1)

ie sort them all as text.

enter image description here

This wouldn't work if you had a mix of (say) 1,2 and 3-digit numbers and wanted to sort them as numbers because 3 (for example) would appear after 23.

Upvotes: 1

Related Questions