sorting letters in words into alphabetical order

  • Thread starter Thread starter bobf
  • Start date Start date
B

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,

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)
 
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?
 
Back
Top