how to detect 5th character?
thankyou very much.. -nastech
"Roger Govier" wrote:
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
|