EXcel 2000 on Win2000

Have to correct a column of names, some enter lname, fname others entered as
fname lname. Following formula correctly places those lname, fname entries(in
column D), however it returns that nasty #Value error for those that are
formatted correctly( inother words do not have the comma separating lname
from fname). My intentions were to simply copy the contents of the D cell, if
there were no ",".

What would be the best way to work around this frustration??

=IF(SEARCH(",", D2)1,RIGHT(D2, LEN(D2)-(SEARCH(",", D2)+1))&" "&LEFT(D2,
(SEARCH(",", D2)-1)), D2)

Thanks for any and all pointers