PROPER function

  • 12 October 2023
  • 0 replies
  • 96 views

Userlevel 5
Badge +4

Description

Capitalizes the first letter in a text string, as well as any letters following non-alphabetic characters, while converting all other letters to lowercase.

 

Syntax

PROPER(Text to Convert)

 

Arguments

Argument Type Dimensions Description

Text to Convert

(required)

Text Any Dimensions Text values to convert.

 

Return type

Type Dimensions
Text Dimensions of Text to Convert

 

Examples

Formula Result
PROPER(“alan storm”) Alan Storm
PROPER(“SUSAN GRAHAM, C@ss n1te, dEaN wHiTe”) Susan Graham, C@Ss N1Te, Dean White
PROPER(“this is a TITLE”) This Is A Title
PROPER(“2-way street”) 2-Way Street
PROPER(“76BudGet”) 76Budget

 

See also

Excel: PROPER

Related articles: UPPER , LOWER


This topic has been closed for comments