anoher way use -data text to columns , delimiter=, (comma) and then
concantenate B1 and A1
you can do a macro on this.

Al Wills wrote in message
...
Hi JMB,

Not quite, I still get lastname, firstname lastname ~ Thanks a lot though,
the post from Biff worked fine!

Thanks a lot!

Al

"JMB" wrote:

if your data starts in cell A1:

=TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) & " " &
LEFT(A1,SEARCH(",",A1,1)-1))


"Al Wills" wrote:

I have work sheet with names listed as last name, first name, I would
like to
have them as just first name last name.

Suggestions??