UPPER

Return text with every letter capitalised.

Syntax

UPPER(text)

Argument	Required	Description
`text`	Required	The text to convert.

Examples

Every example below was executed against VisiGrid engine 0.35.0 — not transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.

Formula	Result	Notes
`=UPPER("ana bo")`	`ANA BO`
`=FIND(UPPER("sheet"),UPPER("Spreadsheet"))`	`7`	Its most useful role — making a case-sensitive comparison case-blind.
`=PROPER("ana bo")`	`Ana Bo`	For title case, PROPER rather than UPPER.

Mostly a comparison tool

Capitalising text for display is rare. Normalising both sides of a comparison so case stops mattering is common, because FIND and SUBSTITUTE are both case-sensitive and VisiGrid has no SEARCH:

=FIND(UPPER(B1), UPPER(A1))

The same trick makes a lookup key case-insensitive when the source data is inconsistent about it.

For title case — capitalising the first letter of each word — use PROPER:

=PROPER("ana bo")     → Ana Bo

Worth knowing that PROPER capitalises after any non-letter, so o'brien becomes O'Brien and hyphenated names gain a capital after the hyphen. That is usually right and occasionally not.

Excel compatibility

Matches Excel.