---
title: "Use the PROPER Function to Convert Text to Title Case"
slug: "proper-function"
description: "Learn to clean and format text with the PROPER function, capitalizing first letters and converting the rest to lowercase."
updated: 2025-05-30T09:42:16Z
published: 2025-08-22T10:57:28Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# PROPER function

## 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](https://support.microsoft.com/en-us/office/proper-function-52a5a283-e8b2-49be-8506-b2887b889f94)

Related articles: [UPPER](/v1/docs/upper-function) , [LOWER](/v1/docs/lower-function)

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>