How can I build a formula (or a macro) to verify the contents of a column (A:A) of text contains only these allowable characters?
Thanks!
How can I build a formula (or a macro) to verify the contents of a column (A:A) of text contains only these allowable characters?
Thanks!
Here is a function that returns TRUE if the string is valid or false if it has an invalid character. The trick that I had to look up was that the hyphen (minus sign) had to be at the end or beginning of the pattern so as not to be confused with defining a range.
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Works like a charm thank you!! Crazy about the dash needing to be at the end too!
Another way:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks