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