View Single Post
  #4   Report Post  
Ken Johnson
 
Posts: n/a
Default

Pat,
Say the column you want filtered that way is column A and assuming
there are no leading spaces, you could put =FIND(" ",A1) into the top
of any other free column then fill down as far as column A. You could
then filter this column, choosing #VALUE! because that is the FIND
function's result when, in this case, a space is not found, indicating
one word.
Does that help?
Ken Johnson