Formula to sort cells containing less & more than a number of characters

Hi,

I have postcode data which I have a VBA code formula to standardise.

That part is set - but I want a fomula which will look at the data and not run the postcode formula if the cells conatins less than 6 characters or more than 8 characters.

I currently have this;

=IF(AND(LEN('Postcodes'!A1)<6,LEN('Postcodes'!A1)>8),"",FormatPostcode('Postcodes'!A1))

But it returns a #NA rather than a blank if the data is to be excluded.

What's amiss please?

Thanks in advance,

Ian

try

=IF(OR(LEN('Postcodes'!A1)<6,LEN('Postcodes'!A1)>8),"",FormatPostcode('Postcodes'!A1))

John's answer looks to have cracked it - let me run over 25k lines of data and will shout if any problems. Thank you all.