=COUNTIF(A1:A50,"EH48 *")


--
Regards,

Peo Sjoblom




"Adam" wrote in message
...
I have a column that contains lots of post codes.

E.g

EH48 3SS
EH48 3HU
EH52 6PQ
EH48 3OP
EH48 3ER
EH52 6XW

I'd like to count how many post codes I have that contain "EH48" in the
cell. Could someone tell me how I do this?

Thanks