Put this in D1 and copy down........

=IF(C1="","",IF(ISNUMBER(C1),3,4))


Vaya con Dios,
Chuck, CABGx3



"Colin Hayes" wrote:


HI

In column C I have a list of reference numbers.

Some of these reference numbers only contain numbers and some contain
numbers and letters.

In column D I need to put a number 3 three for those cells in C which
contain just numbers , and 4 for those cells which contain combined
numbers and letters.

Can some one help with some code for this , please?

Any help appreciated.

Best Wishes