Once again, the Internet saved me a couple of hours of my life (of course, it owes me more than a couple -- can we say E M A I L? Thanks a lot, internet!). Oh right, but I was being grateful here.
We have some open-ended data -- participants were asked an open-ended question, and could write as much or as little text as they would like to in response. A reviewer wanted to know how many words were in each participant's response. We have the data in Excel, and my initial, non-elegant idea was to pull it into a table in Word, and then, cell by cell, have Word do a word count.
But, google to the rescue:
We have some open-ended data -- participants were asked an open-ended question, and could write as much or as little text as they would like to in response. A reviewer wanted to know how many words were in each participant's response. We have the data in Excel, and my initial, non-elegant idea was to pull it into a table in Word, and then, cell by cell, have Word do a word count.
But, google to the rescue:
The first hit was spot on. I recommend you go to the actual blog post, here, for the formula. He has good explanations of why it works, so you can cross check it with your needs and make sure it works for you. Here is the formula I used:
=IF(ISBLANK(CD2),0,LEN(TRIM(CD2))-LEN(SUBSTITUTE(CD2," ",""))+1)
I spot checked and everything seems to work out. Thank you Dave Bruns.
"The post Excel tip #1: Counting # of words" first appeared on Eva Lefkowitz's blog on March 27, 2015."
=IF(ISBLANK(CD2),0,LEN(TRIM(CD2))-LEN(SUBSTITUTE(CD2," ",""))+1)
I spot checked and everything seems to work out. Thank you Dave Bruns.
"The post Excel tip #1: Counting # of words" first appeared on Eva Lefkowitz's blog on March 27, 2015."
RSS Feed
