asked on 10/7/2011

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

Microsoft Excel Microsoft Office

Last Comment

bsharath

12/14/2011

ASKER CERTIFIED SOLUTION

barry houdini

10/7/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

bsharath

10/7/2011

ASKER

thanks
The counts seem to be wrong does it count spaces?

barry houdini

10/7/2011

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

barry houdini

10/7/2011

Here are some examples....

barry
27385877.xls

SOLUTION

Patrick Matthews

10/7/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GrahamSkan

10/7/2011

Can I suggest that the questioner provide some examples where it fails?

bsharath

10/8/2011

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

Michael Fowler

10/8/2011

Please post an example excel with this happening so we can have a look

Michael

bsharath

12/14/2011

ASKER

Hi All,
Any help with this
https://www.experts-exchange.com/questions/27492822/Excel-macro-copy-paste.html