Oct 16 2022 06:59 AM
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
Oct 16 2022 07:11 AM
SolutionDo 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,"")
Oct 16 2022 08:22 AM