You could try using a helper column with a formula like this
=MID(A2,30,6)
and then sort by that. (this assumes your data is all similar in
format/start length)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"clcnewtoaccess" wrote:

I have a column that is text but is a long string and I would like to sort
using a piece of the data. each time I try I get an error.
Example: HEJ,FEJ,123456,987654,111122,223333,444555,
How could I sort this column by 223333?
--
clcnewtoaccess