* Determine Capitalization

		Microsoft Office Forums > Microsoft Excel > Excel
* Determine Capitalization

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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:05 AM.