View Single Post
  #7   Report Post  
CLR
 
Posts: n/a
Default

Highlight the column, then Edit Replace Find what" son of* Replace with:
leave empty Replace all

Vaya con Dios,
Chuck, CABGx3


"Ian" wrote in message
...
On Sat, 9 Apr 2005 11:40:54 -0300, "Bernard Liengme"
wrote:

How about Find & Replace?


No, that won't work because it will only replace part of the cell
contents, i.e. "son of William" would become "William" rather than
blank.