Hi,

I have a list of names that I need to filter out that possibly have their first and last name all in CAPS or their first and last name all in lower case.

Is there a way to filter these names out? I need to figure out which ones have this so I can fix them



By the way this list has over 68,000 names.

Thank you!

I suppose you want a common format? Like only the first letter of both names capitalized?

Yes! Although I don't want to change the names because its a file I exported from our database, I need to condense the file down to the names without proper casing and then send it into development for a mass-update so to speak.

Can you just use the PROPER function?

@ch125 - Please don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post