Introduction
Lower-cases every letter in the given column.
Upper-cases every letter in the given column.
Capitalizes first letter of every word in the given column.
| FORMULA | UPPER(text_col) |
| EXAMPLE FORMULA | UPPER(address) |
| EXAMPLE INPUT | 112 random st |
| EXAMPLE OUTPUT | 112 RANDOM ST |
Sample Usage
| Valid Examples | Invalid Examples |
| UPPER(Text Data Type) | UPPER(Number Column) |
Notes
UPPER, PROPER and LOWER cannot be used with numerical or date data types. Text data types are the only values that will only output desired results.
See Also
TEXT
Still having issues? Contact us at support@gigasheet.com
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article