Hi There,

I am trying to find a formula that will count and return a breakdown of the letters in each word of a cell.

ie. If A1 had text "The Hunchback of Notre Dame" then cell A2 should return "3 9 2 5 4" (3 letters in "The" 9 letters in "Hunchback" etc).

This needs to continue to count for however many works are in A1 and provide the breakdown of letters in each word.

Any thoughts would be helpful.

Thanks in advance for your time.