| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check for CAPS
If all your names are in column A then put this in column B and copy down. It
will show True for the capitals and false for the others =EXACT(A1,UPPER(A1)) "Heidi" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check for CAPS
You are the bomb!!! Thanks much. It was perfect.
"RonaldoOneNil" wrote: If all your names are in column A then put this in column B and copy down. It will show True for the capitals and false for the others =EXACT(A1,UPPER(A1)) "Heidi" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check for CAPS
You are the bomb! This is perfect. Thanks much!
"RonaldoOneNil" wrote: If all your names are in column A then put this in column B and copy down. It will show True for the capitals and false for the others =EXACT(A1,UPPER(A1)) "Heidi" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell Check using All Caps | Excel Discussion (Misc queries) | |||
| In excel can you change words from all caps to initial caps? | Excel Discussion (Misc queries) | |||
| How to change ALL CAPS to Initial Caps only? | Excel Worksheet Functions | |||
| How can I convert all Caps to first letter caps in Excel? | Excel Worksheet Functions | |||
| excel sheet all caps and needs to be only the first letter caps.. | Excel Discussion (Misc queries) | |||
Linear Mode
