Column A Column B
Postcode: XXXX =REPLACE(A1,1,FIND(": ",A1),"")


In column B I am showing the XXXX, but when there is no data it it coming up with #VALUE!

Is there anyway of not having the #Value! and having the box empty?

Thanks