#1
|
|||
|
|||
Excel-find cells that contain all upper cas
I need to search specific columns & identify the cells that contain all upper case. For example, the excel spreadsheet contains multiple columns of information. I need to search the column named "First Name" & the column named "Last Name" & identify which cells contain all upper case letters.
|
#2
|
|||
|
|||
=exact(a1,upper(a1))
|
#3
|
|||
|
|||
Was my posting of any use.
If not - why? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table will not allow sorting because "cells are merged". I can't find the merged cells. | wendyloooo | Word Tables | 1 | 05-26-2015 01:19 PM |
Find incorrect upper case while leaving correct ones? | WaltR | Word | 2 | 02-23-2015 09:09 PM |
Another user name and my picture in upper right hand corner of Word, Visio, Excel, but not Outlook | Coutinho10 | Word | 0 | 12-17-2014 01:22 PM |
Help - Box appeared on upper right of document | Bisteca | Word | 8 | 12-15-2014 05:03 AM |
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only | mag | Excel | 0 | 10-28-2012 08:04 PM |