Hello,

I have been working on a macro to export data to another system. The other system will only read names as Last name, First name Middle Initial. Currently names are displayed in a cell as John E. Smith. I need to covert this (in the same cell) to display Smith, John E.

I have searched the forums and have not found exactly what I needed. Thanks for any help!