N
nastech
Is there a way to tell if there is a 5th characater in a cell, instead of 4?
Thanks - Nastech
Thanks - Nastech
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
Use the LEN() function.
R
Roger Govier
Hi
Try =IF(LEN(A1)>=5,"5th character","No 5th character")
Regards
Roger Govier
Try =IF(LEN(A1)>=5,"5th character","No 5th character")
Regards
Roger Govier
N
nastech
thankyou very much.. -nastech
Roger Govier said:Hi
Try =IF(LEN(A1)>=5,"5th character","No 5th character")
Regards
Roger Govier
N