Split Function

Split Function

Hi,

Is the a split or equivalent function available?  

Here is what I'm trying to accomplish.  If a cell has 5 names (John, Bob, Larry, James, David) I want a count of the names.

In Google docs, I accomplished this by doing 

= counta ( split (A1 , "," ) )

It's hacky but it works.