Forum Discussion
separate single words from multiple words in tabs
Hello everyone Would someone want to think along with my question? thank you! I do keyword research. and I copy these keywords in excel. Sometimes they are sentences, sometimes they are just wo...
I agree with mathetes , depends on goals and way of handling data that could be different solution.
For example, if manually you may add helper column to calculate number of keywords in each cell as
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1filter the range on it and copy/paste results into other sheets.
Approximately the same approach with Power Query, create queries for each number of keywords returning results into the sheet, to update new set it's only Refresh All.
Another way to automate with one button press is with VBA programming.