Formula to change Name format
Try:
=MID(A2,FIND(",",A2)+1,256)&" "&LEFT(A2,FIND(",",A2)-1)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Kiley" wrote:
I have the name:
Smith,Jane A
and I would like a formula that changes it to:
Jane A Smith
|