hawgmech
New member
- Joined
- Feb 24, 2020
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013
Hello,
I have an excel sheet that has a column containing numbers and letters. The letters are plain jane letters and letters with an asterisk (ex. A, B, A*, B*). I need to have the letters sort alphabetically (A,B,C) but the letters that have the asterisk with them need to be alphabetically as well but after the main letter Z (ex. A, B, C...Z. A*, B*, C*).
Any thoughts on how to do this?
thanks
Hawgmech
I have an excel sheet that has a column containing numbers and letters. The letters are plain jane letters and letters with an asterisk (ex. A, B, A*, B*). I need to have the letters sort alphabetically (A,B,C) but the letters that have the asterisk with them need to be alphabetically as well but after the main letter Z (ex. A, B, C...Z. A*, B*, C*).
Any thoughts on how to do this?
thanks
Hawgmech