+ Start a Discussion

sorting alpha and numeric values in text data type field

I have a challenging use case here. I have a customer who has alpha and numeric values and wants to have more control over how the data is sorted. Adding a formula field of num type return wouldn't work since there are two types.