Take a look at
http://www.vbaexpress.com/forum/show...hlight=brettdj



--
HTH

Bob Phillips

"tjtjjtjt" wrote in message
...
Does anyone have a routine that can take a list of names entered as
"Lastname, Firstname" and change those names to "Firstname Lastname"
within
the same cells?

Thanks,

--
tj