Is there a way to Auto SPILL cells with 8 letters (characters) not including spaces from a list

I have a list from A2 to A11 with random words, some cells have single words some have more. I would like to grab all the cells with 8 letters/characters (not counting the spaces) and have them spil...

excel

PeterBartholomew1
Oct 18, 2022
Asparagus
I would suggest
= LET( charCount, LEN(SUBSTITUTE(List," ","")), FILTER(List, charCount=8) )
It is obviously possible to substitute charCount in the FILTER formula but, to my mind, the result is less readable despite being shorter.

PeterBartholomew1

Silver Contributor

Oct 18, 2022

Asparagus

I would suggest

= LET(
    charCount, LEN(SUBSTITUTE(List," ","")),
    FILTER(List, charCount=8)
  )

It is obviously possible to substitute charCount in the FILTER formula but, to my mind, the result is less readable despite being shorter.

Asparagus

Brass Contributor

Oct 19, 2022

This worked great! Thank you so very much!
I don't know how you all do it but it is impressive. This helps a lot.
Cheers

Forum Discussion

Is there a way to Auto SPILL cells with 8 letters (characters) not including spaces from a list

Resources