In N1 enter:
=OFFSET(A$1,ROUNDUP(ROW()/13,0)-1,MOD(ROW()-1,13)) and copy down

this will produce a list of the contents of A1 thru M50 in a single column.

Let's assume that the cells in the table contain either a single word or are
blank. The count of the words is:

=COUNTIF(A1:M50,"<" & "")

--
Gary''s Student - gsnu200831


"milo" wrote:

Hi.

how do I create a list of words and count them as well using formula?
I have cell range (A1:M50) that contain words.

Thanks in advance.