How to convert a string to proper case

Question

How to convert a string to proper case

Dean Isensee 20

How do I convert a string to proper case? eg samson to Samson

George Hepworth 23,120 Reputation points Volunteer Moderator

2026-06-09T11:22:38.2466667+00:00

Where do you need to do this? In VBA or in a query? Your example appears to be a person's name. Is that the type of data you are working with? Or does it include other kinds of data, like country or city names. There are some subtleties to account for, so knowing the context can be helpful.

Help us help you by providing details and context.

Answer accepted by question author

Karl Donaubauer 3,661 MVP

Hi,

StrConv("samson",3)

or

StrConv([YourFieldName],3)

Servus
Karl

Access Forever News DevCon
Access-Entwickler-Konferenz AEK

0 comments

2 additional answers

Your answer

George Hepworth 23,120 Reputation points Volunteer Moderator

2026-06-09T11:22:38.2466667+00:00

Where do you need to do this? In VBA or in a query? Your example appears to be a person's name. Is that the type of data you are working with? Or does it include other kinds of data, like country or city names. There are some subtleties to account for, so knowing the context can be helpful.

Help us help you by providing details and context.

Answer 1

In Microsoft 365 apps, use the built-in “proper case” functions to convert strings like samson to Samson.

In Excel (including Access expressions that use Excel-style functions):

Use the PROPER function:
- =PROPER("samson") returns Samson.
- For a cell value, e.g. A2, use =PROPER(A2).

In Power Query (Power Query M):

Use Text.Proper:
- Text.Proper("samson") returns Samson.

In Power Apps (Power Fx):

Use Proper:
- Proper("samson") returns Samson.

In .NET code (for Office add-ins or automation):

Use TextInfo.ToTitleCase for title/proper case, or String.ToUpper/String.ToLower for full-case changes.

References:

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more