Mass delete cell type

[Sm3tUser]

I used a formula to transfer some information into a column (postcodes). However there are many blank spaces, and I applied the formula to the entire column. This is the result: Imgur
Is it possible to clear only the boxes that have issues? I'm open to any other alternatives.


Thanks

 

[Momentman]

1. Select all cells in the column you want to clear the errors from
2. Press ctrl+G or F5, then select "Special"
3. Select formulas> and check "errors"

This way, only the cells with errors and selected. If you press the delete button at this point, all error cell contents are deleted

 

[Sm3tUser]

Thanks!