|
Back to Excel Tips Index
If you have a column of names that
include first name and last name, but you want to sort by last name, use
this formula as an example of how to put last name first and first name last
so that you can sort by last name.
· In A2, enter your First Name and Last Name
separated by a space as in "Todd Bardoni".
· In cell D2 enter the following formula:
ex. =TRIM(SUBSTITUTE(A2,LEFT(A2,FIND("
",A2)),"")&", "&LEFT(A2,FIND(" ",A2)))
Back to Excel Tips Index |
