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.
Power Query
words list cnt The Hunchback of Notre Dame. The Hunchback of Notre Dame. 3,9,2,5,4 Letter count in each word of text Letter count in each word of text 6,5,2,4,4,2,4 HOW TO ATTACH YOUR
SAMPLE WORKBOOKHOW TO ATTACH YOUR
SAMPLE WORKBOOK3,2,6,4,6,8 I am trying to find a formula, that will count and
return a breakdown of the letters
in each word of a cellI am trying to find a formula, that will count and
return a breakdown of the letters
in each word of a cell1,2,6,2,4,1,7,4,4,5,3,6,1,9,2,3,7,2,4,4,2,1,4
or
Result I am trying to find a formula, that will count and return a breakdown of the letters in each word of a cell 1,2,6,2,4,1,7,4,4,5,3,6,1,9,2,3,7,2,4,4,2,1,4
is that what you want?
Edit:
XL2010 require Power Query add-in to use Power Query (free add-in from MS site)
Last edited by sandy666; 12-01-2022 at 10:25 PM.
what is the result if
semi-final
or full stop at the end of sentences or paragraph.
Regards.
Note: I'm just wonder , can't find the solution yet.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
Are you still using Excel 2010? If you are using 365 or 2021, you could use this:
=TEXTJOIN(" ",,LEN(TEXTSPLIT(A1," ")))
Thank-you all for your time - this formula has worked perfectly!Originally Posted by Gregb11
Glad it worked, but if it did, your Version is incorrect in your profile. Please update it. Many folks may not have answered because of your version.
Benlinus, pleasde take a moment to bring your profile up to date! You are NOT using Excel 2010.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks