Welcome back to the Excel Tip of the Week. As a reminder, one post each month will be posted here in IT Counts, but the regular weekly emails can be found in the Excel Community site. This month we have a General User post in which we'll be looking at three simple text-editing functions. What they do: These three functions all edit the case of one or more letters in a text string. UPPER converts to upper-case font and LOWER converts text to lower-case font. PROPER converts so that the first letter of each word is capitalised. How to write one: The syntax for these functions is very simple, and looks like this:
=UPPER(text) =LOWER(text) =PROPER(text)
Text – The reference to the text you want to alter. See these examples. In each case the code for the function is followed by the output:
What to use it for: - Quick and easy text editing into a desired case.
A quick Copy / Paste Values over the results removes the formulas and leaves you with just the edited text.
Note: Most Excel functions that compare text strings, such as conditional formatting and logicals, are not normally case-sensitive. Previous post - Dropdowns TOTW indexNext post - Formulas with fixed references This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.