Nelson78
Well-known Member
- Joined
- Sep 11, 2017
- Messages
- 526
- Office Version
- 2007
Hello everybody.
Suppose I have a list in range A5:A9
JOHN SMITH
PETER PAN
ROBIN HOOD
MARK TWAIN
ROD STEWART
I've to put this list in alphabetical order for surname (may be in the cell we can invert name & surname, so JOHN SMITH could become SMITH JOHN).
How could I?
Thank's.
Suppose I have a list in range A5:A9
JOHN SMITH
PETER PAN
ROBIN HOOD
MARK TWAIN
ROD STEWART
I've to put this list in alphabetical order for surname (may be in the cell we can invert name & surname, so JOHN SMITH could become SMITH JOHN).
How could I?
Thank's.
Last edited: