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

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

Chip has a very good treatise on this

http://www.cpearson.com



--
Don Guillett
SalesAid Software

"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

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

thanks for the tips and web links everyone!

they were very helpful!



On 2004-05-21 17:02:31 -0600, "Rob van Gelder"
said:

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)