:Table text function PROPER function conversion capitalizes the first letter and lowercase the rest-Table skills免费ppt模版下载-道格办公

Table text function PROPER function conversion capitalizes the first letter and lowercase the rest

Picture and text skills
Case

Converts the first letter of a text string and the first letter after any non-alphabetic characters to uppercase. Convert the remaining letters to lowercase.

Syntax
PROPER(text)
Text Text enclosed in quotes, a formula that returns a text value, or a reference to a cell that contains text.

In Excel table data processing, sometimes you encounter In this case, the format of the English words is not uniform and looks confusing.
Is there any way to quickly convert the first letter to uppercase and the remaining letters to lowercase?
PROPER function is involved here.
Let me give you some instructions to help you understand.

￭First open the form and position the cursor at C3.
Click Insert Function-Text-PROPER Function, and a dialog box will pop up.

￭"String" is the word that needs to be case converted. Enter B3 and click OK.
The first letter of goodNight becomes a capital G, and the remaining letters are lowercase.
Place the cursor in the lower right corner of C3 and pull down the fill formula in a cross shape to perform batch conversion between uppercase and lowercase.

Have you learned this practical trick?

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-wen-ben-han-shu-PROPER-han-shu-zhuan-huan-shou-zi-mu-da-xie-qi-yu-xiao-xie.html

Table text function PROPER function conversion capitalizes the first letter and lowercase the rest

发表回复

评论列表（196条）

Table text function PROPER function conversion capitalizes the first letter and lowercase the rest

Related Suggestion

[Practical tutorial] PPT scientific research drawing tutorial (016) - schematic diagram of electrospinning

[Practical Tips] Illustrated Electrospinning Process: An Introductory Guide to PPT Scientific Research Drawing (016)

The most complete PPT scientific research drawing tutorial and materials in history (second edition)

New version: PPT scientific research drawing complete guide and material collection

"Guidelines for Making Scientific Research PPT Illustrations"

发表回复

评论列表（196条）