This question is cross-posted here...

Reverse name in excel with upper case

and here as well...

http://www.mrexcel.com/forum/excel-q...ml#post3263931