Sort Excel Column on Fifth Character

[Guest]

Hi,

Is it possible to sort an Excel column on the fifth character? If so, how is
it done?

If not, is it possible to write a macro to copy each Excel column to Access,
sort the column on the fifth character in Access, and copy the column back to
Excel? And if so, how?

Would this be further complicated because each Excel column is filled with
items from a drop-down menu that exists only in each column itself?

 

[Guest]

Insert a new column alongside your data and use the MID function to extract
the character on which you want to sort into the new column

Let's assume the column you want to use for sorting is D. Use

=mid(D2,5,1)

to extract the 5th character. Copy the formula to all rows, then sort on
that column

 

[Guest]

Thanks very much, Duke. You're a life saver!