Question Locked

Excel special sort

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to sort by last name, first name. However, with the first 2 letters of the last name and then the first letter of the first name. For example Jourden, Allison would be JO-A. Can I make Excel sort this way?

1 reply

by majamiller

Are your first and last name in different columns or only one column?

This discussion is closed to new replies.