Hello all!
I am trying to identify a list of last names and first names that contain any characters other than a uppercase letter, space or hyphen.
I've been reading the boards, and I see how to test for the existence of a *specific* character or string, but I want to test for characters that are not letters, spaces, or hyphens.
(As I sidenote, I'd like to also test for any cells that begin or end with a space, but I can probably figure that out.)
Thanks!
Pete
I am trying to identify a list of last names and first names that contain any characters other than a uppercase letter, space or hyphen.
I've been reading the boards, and I see how to test for the existence of a *specific* character or string, but I want to test for characters that are not letters, spaces, or hyphens.
(As I sidenote, I'd like to also test for any cells that begin or end with a space, but I can probably figure that out.)
Thanks!
Pete