Assuming there is always a space after the comma...

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

otherwise...

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

--
Rick (MVP - Excel)


"xp" wrote in message
...
Hi,

I have a program that will be supplying a list of names (from another
source) that are in last, first, middle order. See example below (they are
exactly as shown - no periods, etc.):

Brown, Charles
Johnson, Larry M
Wilson III, Tommy William
Johnson Jr, Phil E

I need a function that will loop through and reverse the order so they
read
like:

Charles Brown
Larry M Johnson
Tommy William Wilson III
Phil E Johnson Jr

Can anyone help me out here?

Thanks!