How do I sort a excel file by how many words ie all lines with
Just a caution. This (a) assumes that there are no extraneous spaces
between, before, or after the words (which may well be a good
assumption), and (b) won't find the rows with 1 keyword, which was in
the original specification.
In article ,
ShaneDevenshire wrote:
in a dummy column enter this formula and then autofilter on the number 1.
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))
|