Forum Discussion
Find UPPER except these specific values
I am using this to find improperly formatted name suffixes that are all capitalized, but I am wondering if with additional code I can filter out certain suffixes that are properly in all caps. Some e...
Hi , try this :
SF = IF (
[Suffix] = BLANK (),
BLANK (),
IF(
EXACT(UPPER('132330'[Suffix]), '132330'[Suffix])
AND NOT(EXACT('132330'[Suffix], "JR.")),
"yes", "no"
)
)