Hi
as a starting point see:
http://www.cpearson.com/excel/FirstLast.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Will Tyson" schrieb im Newsbeitrag
news:2004052115161729886%weric@lobalopecom...
I'm very new to VB and Excel, and I have been given a project at
work.
I need to convert name data in cells from smith, john to john smith.

I was hoping I could run a VB function on the cells to reorder the
names. I looked in the help files for examples and the closest
thing
I found was to split the cells into columns, but that won't work for
me.

can anyone help me out with this?

Thank you

Will