Hello macroprod,

Many thanks for your speedy and clear response. My mistake is that I expected when within the main CTRL+F9 logic portion that keyed in brackets would be noted accordingly. Your corrections were most helpful in finding my errors.

All is working as expected thanks to you but was hoping for a follow-up question if you had time. I have included a sample of the end product and as you can see there is an extra space when the text, if applicable, would be placed. Would you be able to provide insight into how to remove this extra row while stillkeeping text, when present, on its own line? I have included the section of logic as well.

I will address the MERGEFORMAT as you mentioned just making incremental changes to track if issues.

Many thanks,

Derek

Attached Files

	If Then_Corrected.docx (12.3 KB, 11 views)
	NOTICE TO QUIT FOR NONPAYMENT OF RENT.docx (14.6 KB, 10 views)