Case Sensitive functions in Excel

  • Thread starter Thread starter Tomeka L. Lee
  • Start date Start date
T

Tomeka L. Lee

Are there any formulas available in Excel that will
automatically modify letters to upper or lower case? For
example: If I have the name henry and HENRY in my
worksheet is there any function that will recognize this
and automatically change the case. In addition, if I
have a name McDonald, that is put into Excel as MCDONALD,
is there a function for that also?
 
Tomeka,

=UPPER(Cell Ref) will make all the characters uppercase,
while =LOWER(Cell Ref) makes all the letters lowercase.

HTH
Kevin M
 
Hi Tomeka,
A function will not change the content in place, you need a macro.
To specifically change the content when you make a change you
need an Event Macro.

You can run a macro to change a selection such as a column so that
words get changed to proper including names like "macdonald"
getting changed to "MacDonald".
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

The macro was split into two parts specifically to make it easier
to invoke the macro in various ways, including via an event macro.

Using the same macro as is actually doing the work, you can
invoke it with an Event macro.
Invoking a Change Event macro to change to Proper Case
http://www.mvps.org/dmcritchie/excel/proper.htm#proper_change

 
You guys are the greatest, I have been trying to figure this out for the longest time.
 
Back
Top