Help Modify Cells with Names

[3qtpiesok]

I have an Excel spreadsheet that is being used for a mailing list. The name field shows names such as: David Smith & Jill Smith. For the mailing I need it to show: David & Jill Smith. Is there a way to write some type of macro that tells the system to deleted the word before the ampersand?

Thanks.

 

[shg]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=539788