Thank you

"Gary''s Student" wrote in message
...
say a1 has the full text and a2 has the character to be counted:

=LEN(A1)-LEN(SUBSTITUTE(A1,A2,""))

For the data between \
use Text to Columns
--
Gary''s Student - gsnu200747


"dan" wrote:

Is there a formula that returns a count of a specified character?
For example:
Cell(A1) = I:\1stFolder\2ndFolder\3thFolder\4thFolder\5thFold er\abc.xls
Answer would be 6 for "\"

And also a formula that returns a folder name between 2 consecutive "\"