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

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

Hi!

Use Data Text to columns. Set switch as fixed length and use length =
1
This will expand the word to one letter per column which is sortable
using Data Sort Options Sort left to right.

Alf

Hi!

Use Data Text to columns. Set switch as fixed length and use length =
1
This will expand the word to one letter per column which is sortable
using Data Sort Options Sort left to right.

Alf

You've been told how to split the data, but my question for you is, WHY do you
want/need to do this?

On Mon, 21 Mar 2005 00:37:17 -0800, "bobf"
wrote:

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

Myrna:

Gosh! I've never felt so bold I could ask that...

Alf