Something like this:

=MID(A2,FIND(" ",A2)+1,255)&" "&LEFT(A2,FIND(" ",A2)-1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mike F" wrote:

I have a cell with the name Doe Jane.
Is there a way I can invert the information in the cell to read 'Jane Doe'?