Thread: Check for CAPS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heidi Heidi is offline
external usenet poster
 
Posts: 75
Default Check for CAPS

I have a list of names in this format:

Johnson,Dave
Smith,Karen
MENDOZA,JUAN

I need to run a check and identify all the cells where the name is in all
CAPS.

Can someone help?