There's probably an easier way, but here's something that may work:

=TRIM(MID(A1, FIND(",", A1, 1) + 1, LEN(A1))) & " " & MID(A1, 1, FIND(",",
A1, 1) - 1)


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Will Tyson" wrote in message
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