Counting number of names in a single cell

I am new to excel formulas, so need help with how to count up the number of names in each cell in my table, if anyone cane help? ie: 7 names in cell 1, 2 names in cell 2, 4 names in cell 3

Cell 1     Cell 2           Cell 3

Paul,

Jane,

Susan,

John,

Simon,

Jill,

Jack,

Andrew,

Karen

   Amy,

 Alfie,

  Liam,

Nina

  Many thanks                                 

 

 

 

 

 

By: Sandra

Leave a Reply

Your email address will not be published. Required fields are marked *