Forum Discussion
Solved
How to extract only 4 letter words from a column into another column without them being spaced apart
Is there a formula that will extract only the 4 letter words that I have in column A into column C, but with out them having any spaces beneath each word? If more words are added into column may the ...
Do you have Microsoft 365 or Office 2021 (or are you using Excel Online)?
If so, enter the following formula in for example C2. Excel will automatically spill it to the cells below as needed.
=FILTER(A2:A1000,LEN(A2:A1000)=4,"")
Do you have Microsoft 365 or Office 2021 (or are you using Excel Online)?
If so, enter the following formula in for example C2. Excel will automatically spill it to the cells below as needed.
=FILTER(A2:A1000,LEN(A2:A1000)=4,"")
- Awesome! This worked perfectly. I have Microsoft 365, it is brilliant!
Thank you so much and for the quick response!!
