Mar 24, 2014
Using the COUNT and COUNTA functions, this short tutorial demonstrates how to count the number of items in a list in Excel
Mar 16, 2014
This week I received an email from someone who had 258 cells containing strings that they wanted to combine into a single cell. Rather than using VBA, I worked out another way to do it. This video shows you how. Note that the CONCATENATE function has a limit of 255...
Sep 1, 2013
Are you planning an event with a global audience? Let the world know at what time your webcast, webinar, or chat will begin or when to tune into an upcoming premiere, concert, or game. The timeanddate.com Event Time Announcer converts the time of your event to the...
Mar 14, 2013
The CONCATENATE function is used to join the contents of cells together. Here’s a couple of examples of how to use it: Example 1 In the example above, D2 contains the formula =CONCATENATE(A1,” “,B1,” lives in “,C1) This joins the text in...
