sorting letters in words into alphabetical order

[bobf]

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 Phillips]

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)

 

[AlfD]

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

 

[AlfD]

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

 

[Myrna Larson]

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

 

[AlfD]

Myrna:

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

Alf