Forum home » Delegate support and help forum » Microsoft Excel Training and help » Counting in columns
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Counting in columns
Resolved · Low Priority · Version 2007
Reply Fri 15 Jul 2011, 16:42Delegate Adam said...
For upcoming training course dates see: Pricing & availability
RE: 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
Mon 25 Jul 2011: Automatically marked as resolved.
|