My records are "item codes" - {'ESL_Svc_Codes_'.Item Code} which do not sort in the order I want them.
Example: "/ES103" is positioned after "/ES10".
/ES10
/ES103
/ES12
etc
I want to convert them or do whatever I need to so they will sort as follows:
/ES10
/ES12
/ES103
Please assist with formula. Thanks!
Example: "/ES103" is positioned after "/ES10".
/ES10
/ES103
/ES12
etc
I want to convert them or do whatever I need to so they will sort as follows:
/ES10
/ES12
/ES103
Please assist with formula. Thanks!