Marcol,

Cleaning a worksheet will take some time, but maybe I can explain better.

Say you had a group of people (nine people max) who you were going to send a letter to.

So depending on what names where on those cells determines who is on the "To:
block of the letter.

So the formula for the actual "To:" block would be:

="To: "& UPPER(IF(C4="","",C4&", "&C5&IF(C6="",""," "&C6)&REPT(CHAR(10),2))
&IF(D4="","",D4&", "&D5&IF(D6="",""," "&D6)&REPT(CHAR(10),2))
&IF(E4="","",E4&", "&E5&IF(E6="",""," "&E6)&REPT(CHAR(10),2))
....

The output would be:

To: SMITH, JOHN RICHARD

JONES, MICHAEL WILLIAM

JACKSON, SAMUEL L.

Since only three names were entered, that ends the formula. More names = a longer list.

I was wondering if there was a trick to squash the formula down since it looks at C4,C5,C6, then E4,E5,E6, then F4,F5,F6, etc.

HTH!

VR/Lost