Forum Discussion
Delete cells with exactly three syllables
I'm not sure if this is too specific a command to use in Excel, but I have a column in which I want to delete all cells in that column with exactly 3 syllables in them. Is this even possible?
This is what it would take to solve in Excel.
- Pull together a list of the most common syllables found in English.
- Pull together a list of the most common words (or words most relevant to your data)
- Create all possible permutations (with repeats) from the list.
- Discard words which do not match words in your dictionary
- Discard words with precisely 3 syllables.
My advice is to use the best version of Copilot at: https://copilot.microsoft.com/
You can fit about 12,000 characters in a single chat post.