View Single Post
  #1   Report Post  
Cameron Stewart
 
Posts: n/a
Default Function / formula to be used if cell contains a letter.

I have a colum of values that includes data such as this:

1.9825
1.8770a
1.4617
1.02x20
1.4061
1.4163c
1.8002
2.4261
2.9756
3.6d679
1.6860

I want an if statement that says - if cell value contains ANY LETTER then . . . .

(NB - the letter may be in any position in the number sequence.)


Any Help?

Cameron