Bob,

You need to strip them out as Sort has no substring facility in the key.

Other than that you need VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bobf" wrote in message
...
I have an Excel column of surnames. Is there any way of
sorting the letters within each surname into alphabetical
order, OTHER than by using left, mid and right functions
to strip out the individual letters and then perform a
sort on them. Thanks in advance. Bobf