When using the LOWER function, common questions usually involve formula errors, unexpected results, and batch filling; this FAQ includes 3 common questions and a short glossary.
FAQ
What should I check first if the LOWER result is not correct?
- Check whether the formula syntax is
=LOWER(text or cell reference). - Check whether the referenced cell contains the text you want to convert.
- Make sure you are looking at the result cell instead of the original text cell.
Why do I not see a lowercase result after entering the formula?
- Make sure the formula starts with an equals sign
=. - Press Enter to submit the formula and let the cell calculate.
- If the cell shows the formula text itself, check whether the cell is formatted as text and then enter the formula again.
How can I use the LOWER function in multiple cells?
- Enter the correct LOWER formula in the first result cell.
- Move the pointer to the fill handle at the lower-right corner of the cell.
- Drag down or double-click the fill handle to copy the formula to other rows.
Glossary
| Term | Definition |
|---|---|
| LOWER | A text function in WPS Spreadsheet that converts uppercase letters in text to lowercase. |
| Cell reference | A formula reference to a cell location, such as A1 or B2. |
| Fill handle | The small square at the lower-right corner of a selected cell, used to copy formulas or extend calculations. |