Wont that be a circular reference, when I put in

D2 =TRIM(RIGHT(D2,LEN(D2)-FIND(" ",D2,1))) ?

Another issue is that the columns A:D are being copied by another macro
in the same module into this worksheet. So I dont know if this would
work. Please advise.

thanks,

Joe.