* Determine Capitalization

		Microsoft Office Forums > Microsoft Excel > Excel
* Determine Capitalization

FAQ

Thread Tools

Display Modes

05-03-2011, 10:52 AM

djreyrey

Windows 7

Office 2007

Novice

Join Date: Mar 2010

Posts: 21

I just found exactly what I was looking for. Here's the formula:

=IF(EXACT(B4,LOWER(B4)),"Lower Case","")

All I needed to know was which ID's in Column B where lower case.

Thanks for your efforts!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to determine a user's mailbox size limit?	enviroko	Outlook	3	05-13-2010 07:02 AM
Macro to determine attached template	zippyaus	Word VBA	0	03-02-2010 02:05 AM
Anyway to determine time/date of text creation?	pureride	Word	1	01-05-2010 02:09 PM
Determine age by using birthdate	gdodson	Excel	1	08-11-2006 09:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:16 PM.