One way:
=IF(ISERROR(SEARCH(",",D2)),D2,RIGHT(D2,LEN(D2)-(SEARCH(",",D2)+1))&"
"&LEFT(D2,(SEARCH(",",D2)-1)))

HTH,
Paul

"JR Hester" wrote in message
...
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