I'm trying to figure out how to easily sort feet and inches.
Let's say I have a column with only feet..
IE:
34'
355'
154'
1503'
14' 6"
10' 7"
50'
How could I sort this? I want to go greatest to least, and least to greatest. However, I'm having a hard time figuring this one out..
Any tips?
Trying to avoid any formulas, or converting it to a decimal or inches and then sorting.. Tips?
Let's say I have a column with only feet..
IE:
34'
355'
154'
1503'
14' 6"
10' 7"
50'
How could I sort this? I want to go greatest to least, and least to greatest. However, I'm having a hard time figuring this one out..

Trying to avoid any formulas, or converting it to a decimal or inches and then sorting.. Tips?