Home : LOWER
Q11552 - INFO: LOWER

LOWER (Primitive Spread Function) converts text to lowercase letters.

SYNTAX:

LOWER(value)

REMARKS:

The value argument is the text you want to convert to lowercase. The LOWER function does not change characters in value that are not letters.

The value argument can be a string, a formula that returns a string, or a reference to a cell containing a string. 

EXAMPLES:

LOWER("Road Race 2") equals road race 2

Related Articles
Q11516 - INFO: CHAR
Q11547 - INFO: LEFT
Q11557 - INFO: MID
Q11576 - INFO: PROPER
Q11585 - INFO: RIGHT
Q11612 - INFO: UPPER

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 8/26/2008 5:07 PM.
Last Modified on 8/26/2008 5:07 PM.
Last Modified by No Author Name Available!.
Article has been viewed 2965 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article