View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kokhong kokhong is offline
external usenet poster
 
Posts: 19
Default counting number of word in a cell

is there a function can count number of word in a cell

example:

A B
username count
kok, hong, Lee
chan, NG
Ti, Lee

after counting
A B
username count
kok, hong, Lee 3
chan, NG 2
Ti, Lee 2