UPPER, LOWER, PROPER

Modified on Thu, 30 May at 1:20 AM

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.


FORMULAUPPER(text_col)
EXAMPLE FORMULA
UPPER(address)
EXAMPLE INPUT
112 random st
EXAMPLE OUTPUT
112 RANDOM ST


Sample Usage


Valid ExamplesInvalid 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article