Jane Fischer
Board Regular
- Joined
- Feb 6, 2006
- Messages
- 85
I have a column that contains first and last name. Is there a way to switch it to last name then first? Someone sent one of our users a file and she needs it by last name.
Book2 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
7 | ||||||
8 | Jane Fischer | Fischer Jane | ||||
Sheet2 |
Book3 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | JohnDoe | Doe,John | ||||
2 | SusieSmith | Smith,Susie | ||||
3 | HarryPotter | Potter,Harry | ||||
4 | Mr.T | T,Mr. | ||||
Sheet1 |
another way ?...here's another way
=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))