View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jezzica85
 
Posts: n/a
Default Counting words with numbers in them

Hi all,
If I have a row of words and numbers like this:

example
1922-example
anotherexample
3311
athirdexample
332

Is there a way to use the COUNTIF function to count how many of these words
are numbers, and how many start with numbers? So, in this example, 1 word
starts with a number, and 2 are numbers. Failing that, is there a way to
just count how many words have numbers in them, so there would be 3 in this
example? Thanks!