AnsweredAssumed Answered

What sort of sort will sort this out?

Question asked by PeterWindle on Apr 7, 2018
Latest reply on Apr 12, 2018 by user19752

I have a challenge.

I wish to sort a field that contains product names, however, there are names as text, names as numbers and names combined with numbers...

 

eg:

 

100

150

1500

Apple Trees

Evergreen 100

Evergreen 150

Evergreen 2000

Gumtrees

 

and this is how I would like them sorted...

 

can one calc fit all?

Outcomes