| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count commas in a cell?
Hi Everyone
I have cells with lists of people in them (ie as a list of names, divided by commas. I need to count the total number of people in all the cells. For instance, A1 = Tom, John, Bob A2 = Kate, Uma, Deidre I figure if I can count the commas and add 1 to each cell, I'll have the solution. But I can't get the count functions to work on a comma (not even as ",") Could someone point me in the right direction? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i add commas in a single cell? | Excel Worksheet Functions | |||
| Count the number of Commas found in cell A2 | Excel Worksheet Functions | |||
| formula to count commas | Excel Discussion (Misc queries) | |||
| Count values between commas | Excel Discussion (Misc queries) | |||
| Count Commas in Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
