criteria to pull alpha info. only?

[Guest]

How do I set criteria to pull alpha info. only?

Thanks

 

[Vincent Johns]

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.

 

[Guest]

That worked great, thanks for your help.