VB function to reorder names?

[Will Tyson]

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

 

[Frank Kabel]

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

 

[Don Guillett]

Chip has a very good treatise on this

http://www.cpearson.com

 

[Rob van Gelder]

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)

 

[Will Tyson]

thanks for the tips and web links everyone!

they were very helpful!