You can't do it directly unless you use a macro. The easiest was is to flip
the names around with a formula and then
copy / paste special - values
the correct names over top of the original...

The formula could be something like this...

=MID(A1,FIND(",",A1)+2,256)& " " & LEFT(A1,FIND(",",A1)-1)
--
HTH...

Jim Thomlinson


"Dreamy" wrote:

In Excel 2003 how do I change a name in single cell that is last, first to a
first last name still in the same cell ?