Use
=DateValue(Left(cell,8))

in another column and sort on that.

--
Regards,
Tom Ogilvy


"Struggling with VBA" wrote in
message ...
I had a look on replies but didn't see what I was looking for.

What I am trying to do is perform a sort based on

a. The user selecting the range
b. The sort being performed on the first few characters of a string (a
date value - in
MM/DD/YY format)

If possible I want to automate this as a right click option but am not
sure if this
will work? Although getting a sort routine working would help and I could
try to figure out myself if I can right click to operate it.

Thanks in advance


The data has (3 columns the middle one being the string containing the
text and date value)