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