Change order of data in a cell

[Mary-Anne]

file codes are formatted Name_Initials of person responsible for file. IE
GHOPO_MP. MP is therefore responsible for the file GHOPO. I want to sort
the list of files by my initials. ie MP. How can I change the order so that
MP comes first? Or ... Can I find and replace MP in a different cell. And
then sort on that column?

Help please - I am using Excel 2000.

 

[Mike H]

Mary Anne,

I'd extract the initials to a helper column and use that as the sort key.
With your data in A1 down put this in B1 and drag down.

=MID(A1,FIND("_",A1)+1,LEN(A1))

Mike

 

[Mary-Anne]

Fantastic! Works beautifully. Thank you so much. Sorted so easily and
quickly.

 

[Mike H]

Glad I could help

Fantastic! Works beautifully. Thank you so much. Sorted so easily and
quickly.