Thread: How do I reverse information in a cell example last name, first n
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
  
Posts: 268
Default How do I reverse information in a cell example last name, first n
Say you have your name and surname in A2, then in B2 enter this formula
=MID(A2,FIND(" ",A2)+1,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)

"elrusty" wrote:

Need to reverse information in a cell example last name, first name
Reply With QuoteReply With Quote