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