Book6 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Smith Mike | Mike Smith | ||||
2 | James Frank | Frank James | ||||
3 | Little Susie | Susie Little | ||||
4 | Williams Patrick | Patrick Williams | ||||
5 | ||||||
Sheet1 |
Book6 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Smith Mike | Mike Smith | ||||
2 | James Frank | Frank James | ||||
3 | Little Susie | Susie Little | ||||
4 | Von Williams Patrick | Patrick Von Williams | ||||
5 | Daniels C. Peter | Peter Daniels C. | ||||
6 | ||||||
Sheet1 |
Insert a new column B.Matkalg said:what about changing the names around in the same cell to still end up in the same cell but round the right way
=MID(A1,FIND(" ",A1,1)+1,LEN(A1))&" "& LEFT(A1,FIND(" ",A1,1)-1)