Hi Eva at Work,

You could try:
=IF(ISTEXT(A1)=TRUE,"",A1)

Where A1 holds zipcodes.

The formula evaluates the cell to see if there is any text in it, ie abcde,
if so it returns nothing, otherwise it returns the value of the cell.