Thread
:
Flipping a last name comma first name in the same cell
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Raymie Younkin
external usenet poster
Posts: 1
Flipping Names in same cell
=&RIGHT(C3,LEN(C3)-FIND(",",C3,1))&" " &LEFT(C3,FIND(",",C3,1)-1)&
Where C3 is the cell with the name formatted as
Smith, John
Reply With Quote
Raymie Younkin
View Public Profile
Find all posts by Raymie Younkin