how do you redo huber, Casey to Casey Huber using a macro

[Guest]

If I have a list of rows that are listed as last name then first name (huber,
casey) how can I select a range and change them to First name then Last
(Casey Huber).

 

[Jim Cone]

Chip Pearson has some methods here...
http://www.cpearson.com/excel/FirstLast.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"huber"
wrote in message
If I have a list of rows that are listed as last name then first name (huber,
casey) how can I select a range and change them to First name then Last
(Casey Huber).