Excel formula that can count the words in the adjacent cell.
Excel formula that can count the words in the adjacent cell.
Say i put it in C2 it has to check B2 and give me the word count
please help need this URGENT
Say i put it in C2 it has to check B2 and give me the word count
please help need this URGENT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
TRIM takes out excess spaces (just in case you have some at the end....or two spaces between a word) and then the formula counts the spaces left and adds 1 - that would normally give an accurate word count. Can you give an example that's not working, do you have some other character separating the words?
regards, barry
regards, barry
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can I suggest that the questioner provide some examples where it fails?
ASKER
Hi All.. Thanks
The formula does work
Say i get the results as 96 words and when i paste the words into word file it shows me 105. So was wondering where are those 11 words difference coming from
The formula does work
Say i get the results as 96 words and when i paste the words into word file it shows me 105. So was wondering where are those 11 words difference coming from
Please post an example excel with this happening so we can have a look
Michael
Michael
ASKER
Hi All,
Any help with this
https://www.experts-exchange.com/questions/27492822/Excel-macro-copy-paste.html
Any help with this
https://www.experts-exchange.com/questions/27492822/Excel-macro-copy-paste.html
ASKER
The counts seem to be wrong does it count spaces?