criteria to pull alpha info. only?

  • Thread starter Thread starter Guest
  • Start date Start date
By deciding how to recognize it. Do you consider "ABC" to be alpha? (I
assume so.) What about "Three"? Or "222XX"? Or "123.45"?

You may be able to use the "Like" operator to distinguish, but if not,
you can always go into VBA and write a function which examines the value
in as much detail as you wish to apply, and which will return "Yes" or
"No" according to what it finds.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top