I have to create a report using an application that exposes extra functions in excel. The database that contains the data that is being pulled into excel is null padded. A null value can be represented by CHAR(0) but excel only allows char values greater than or equal to 1. Does anyone know of a way that I can pad the data in excel with null values so that I can use that cell as a filter?