B Bob Phillips Jan 8, 2004 #4 =LEN(A1) gives the number of characters in A1 =LEN(A1)-LEN(SUBSTITUTE(A1,"A","")) counts the incidents of a particular string in A1 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
=LEN(A1) gives the number of characters in A1 =LEN(A1)-LEN(SUBSTITUTE(A1,"A","")) counts the incidents of a particular string in A1 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
