I can't see the original thread (so I don't know if I already offered this
solution to you or not), but here is another solution you may want to
consider...

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

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

otherwise (which will work if the space is there or not)...

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

--
Rick (MVP - Excel)


--
Rick (MVP - Excel)


"Kumar" wrote in message
...
This formula works. Thanks for sharing it.

"Gary''s Student" wrote:

With a name in A1 use:

=REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"")
--
Gary''s Student - gsnu200781


"Té" wrote:

Is there a way I can reverse first and last names in Excel when the
first and
last name is within one cell?
When my software exports it last name, first name it brings it into one
cell.