If you have done any downloading of Inquiry information into Excel, you will
notice that all of the wording comes in as capital letters. A list of names
that are capitalized from other sources can easily be changed to lower case or
mixed case with functions available in Excel.
Example: If you have a column of all uppercase names, convert them to first
letter capital by using the "PROPER" function. Simply insert a new column next
to the column to be converted, insert the formula "=PROPER(original cell
location)" and the new column will display the name with Upper and Lower case
letters. Then copy the formula into the rest of the column and you are done!
Similarly, if you want to change all lower case letters to upper, use the
"=UPPER" function, and changing all upper case to lower, use the "=LOWER"
function.
If you have a tip that you have learned and would like to share related to ELF,
HRMS, Inquiry, FRS, or any other frequently used system, please submit them to
vnye@wesleyan.edu to be shared in the next edition.
