Counting in columns

Hi Adam,

Thank you for your question and welcome to the forum.

Do you mean you are trying to count how many words in a column?

If so use the CountA function e.g. =counta(a1:a5"), then
if there was text in each of those cells the answer would be 5.

OR

Do you mean you are trying to combine two pieces of text so they appear as a combined entry in a cell?

If so use the following formula:

= a1&" "&b1

This will join the values in the two cells and place a space between the two values.

I hope this answers your question.

Regards

Simon