Hi,

I am making a content database and need to count the number of words in each cell...

I know you can count them with

=IF(LEN(TRIM(A2))=0,0,LEN(TRIM(A2))-LEN(SUBSTITUTE(A2,” “,””))+1)

but the the cells have line breaks so this formula won't work

I've understood that since there is a space before the new line, the formula will not recognise the space and therefore not recognise a new word.

Any ideas on how I can work this out?