You could use the length of the field as a check:
=LEN(A1)

or the length without slashes:
=LEN(SUBSTITUTE(A1,"/",""))

or the number of slashes:
=LEN(A1) - LEN(SUBSTITUTE(A1,"/",""))

Use Data | Text to Columns to split the field up

Regards

Trevor


"Finger Tips" wrote in message
...
I have the following field titled Path as part of a full query, that
has the following format of data, each row in the same format but
different
text.

/Community & Government/Social & Human Services/Individual &
Family/Abuse/
Other rows in this field contain just

/Community & Government/Social & Human Services/

0r

/Community & Government

or
A/

I am looking to run the query so it returns only listings that contain
the
four /../../../../ and then seperate the four into seperate fields.