How to ignore text in number column when sorting eg 2cm
How to ignore text in number column when sorting eg 2cm
techbot
Posts: 9Questions: 4Answers: 0
From what I can tell if I remove the 'cm' everything is fine. But with the 'cm', all the cells are ordered alphabetically so my result is
1 cm
10 cm
2 cm
when ordered.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Two options:
Allan
thank you Allan.