View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default how do i switch the first and last name in a cell?

hi
an example of your names would have been nice. are the seperated by comma?
if so try this.....
=MID(A6,FIND(",",A6)+2,255)& " "&LEFT(A6,FIND(",",A6)-1)
if not, post some examples of what you are trying to reverse.

Regards
FSt1

"Slac" wrote:

I want to switch a person's first and last name in a cell, what should I do?