The function capitalizes the first letter in a spreadsheet

The function capitalizes the first letter in a spreadsheet


Excel supports the first letter uppercase function in a spreadsheet when editing text, which is a lot more useful than holding Shift or pressing Capslock to capitalize the first letter as if you had to type the first name. , Sites. The following article will guide you about the first letter capitalization function in Excel worksheet.


On the Word app, turning on / off the feature Automatically capitalize the first letter in a sentence very easily, because this is specialized software for word processing and formatting. However, in Excel this function only supports automatically capitalizing the first letter after the period (.), But for the first sentence in a cell, Excel does not support. Therefore users often have to use manually press Shift to do this job. Or enter normal information and then use the built-in functions or the self-writing functions to standardize your own.

Learn the first capitalization function in Excel 2016, 2003, 2007, 2010, 2013

The first letter capitalization functions in Excel are especially useful for users when manipulating data on spreadsheets. You can use these functions to convert thousands of pages long Name column into capitalized or capitalized format easily instead of manual operation, which takes a lot of time. And in this article, Taimienphi will introduce you to some function capitalizes the first letter In the spreadsheet you can read, refer to.

Table of Contents:
1. The Proper function
2. Upper function
3. Use the Visual Basic Editor

Instructions for using the first letter of Uppercase in Excel

1. PROPER FUNCTION

a. Function: Converts the first character in the string to uppercase.
b. Syntax: PROPER (text)
Where: Text is a string or a reference to a string to be converted.
c. For example.
Example 1: You can pass a string as follows:
= PROPER (“free download”)
After pressing Enter, the string will change to “Tai Mien Phi”.
Example 2: Reference to string to be converted
I have the following list:

First letter in the first language in excel

I want to move the first characters of Name into words I do the following
+ At the umbrella B5 we type the following B5 = PROPER (C5) then press Enter We get results.

First taste of Vietnamese first flower

+ Use the mouse to drag and drop to perform for the remaining cells

First letter in the first language in excel

2. UPPER FUNCTION

Jaw UPPER: Capitalize all letters
+ At the umbrella D4 we type the following = PROPER (B4) Then press Enter to get the results.

Ham Vietnamese chu Cai dau dau bang bang

+ Use the mouse to drag and drop to perform for the remaining cells

First taste of Vietnamese capital in the state of planet

3. Use the Visual Basic Editor

– You clicked Alt + F11 to open Visual Basic Editor.
– Copy the following code and put in:

Function CapitalizeSentence (ByVal strContent As String) As String

Dim m As Object

strContent = LCase (strContent)

strContent = Application.Replace (strContent, 1, 1, UCase (Left $ (strContent, 1)))

With CreateObject (“VBScript.RegExp”)

.Pattern = “. S.”

.Global = True

For Each m In .Execute (strContent)

strContent = Application.Replace (strContent, m.FirstIndex + 1, m.Length, UCase (m.Value))

next

End With

CapitalizeSentence = strContent

End Function

Or

Function CapitalizeSentence (txt As String) As String

Dim e

For Each e In Split (txt, “.”)

SentenceCase = SentenceCase & “.” & UCase (Left $ (Trim (e), 1)) & LCase (Mid $ (Trim (e), 2))

next

SentenceCase = Mid $ (SentenceCase, 3)

End Function

You then use the above functions to perform your calculations.

Thus, through the functions that we introduced above, you can apply the option of uppercase uppercase functions in Excel above to serve your calculations. It will help your work get resolved faster. Also, you can refer The function to remove Vietnamese diacritics in Excel, …

First taste of Vietnamese capital in the state of planet

Do you know that in addition to the commonly used Vlookup and Hlookup lookup function, we can also use the Index and Match functions to perform data lookups in rows and columns of different tables in Excel.

https://thuthuat.taimienphi.vn/ham-viet-hoa-chu-cai-dau-tien-rong-excel-2047n.aspx
You can refer to the article converting VnTime to Time New Roman in Word and Excel if you want to change the font from VnTime to Time New Roman without knowing how to do it. How to convert VnTime to Time New Roman in Word and Excel is not as difficult as you think.

.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *