Excel formula to count words in a cell

It’s reports time again – specifically UCAS references time. And I need to write up to 140 words on each of my students.

I like using Excel for such things but was surprised there was no easy way of counting the words in each cell. I knew you could count characters using LEN() but not how to count the words…. till I found this post and this useful snippet:

=LEN(TRIM(text)) - LEN(SUBSTITUTE(text, " ", "")) + 1

Pushing ahead with Python

So this summer I’ve been coding in Python.

I’v decided to push this in my A Level classes more than learning VB.net, Javascript & PHP. Not because I don’t enjoy doing these languages, but that some students would struggle with switching between these. Perhaps code agnostism only comes with a maturity of having to learn different programming languages over the years?

Read more…