SOLVED

How to extract only 4 letter words from a column into another column without them being spaced apart

Brass Contributor

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 formula automatically place them into column C? 

 

I am not sure if it matters but column A has a header. 

Thanks

2 Replies
best response confirmed by Asparagus (Brass Contributor)
Solution

@Asparagus 

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!!
1 best response

Accepted Solutions
best response confirmed by Asparagus (Brass Contributor)
Solution

@Asparagus 

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,"")

View solution in original post