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?
|