Thread: name formats
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 93
Default name formats

This is if info is in A1 and there is a space between first and last
=RIGHT(A1,FIND(" ",A1))& ", "&LEFT(A1,FIND(" ",A1))

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Todd Taylor" <Todd wrote in message
...
I'm trying to flop names in a cell from First Last to Last, First