Hi

Try =IF(LEN(A1)=5,"5th character","No 5th character")

Regards

Roger Govier


nastech wrote:
Is there a way to tell if there is a 5th characater in a cell, instead of 4?
Thanks - Nastech