How to write an IF Statement to look for NOT null

In our app we converted 400 projects that had historical SPONSORS as a text field.  Approximately half of the projects are closed so we plan to keep a Sponsor-Historical (text field) for closed p...