Scribd
Upload
6 views2 pages

Text Function

The document provides a table of Excel functions along with their purposes, examples, and expected results. Functions include CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM, and LEN. Each function is designed to manipulate or analyze text in specific ways.

Uploaded by

juraijvuit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

Text Function

The document provides a table of Excel functions along with their purposes, examples, and expected results. Functions include CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM, and LEN. Each function is designed to manipulate or analyze text in specific ways.

Uploaded by

juraijvuit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Function Purpose Example Result

CONCATENATE Combines text =CONCATENAT HelloWorld


() strings E("Hello",
"World")

TEXTJOIN() Joins text with =TEXTJOIN(", ", Apple, Banana


a delimiter TRUE, A1:A3)

LEFT() Extracts text =LEFT("Excel", Ex


from the left 2)

RIGHT() Extracts text =RIGHT("Excel cel


from the right ", 3)

MID() Extracts text =MID("Excel", 2, xce


from the 3)
middle

UPPER() Converts text =UPPER("excel" EXCEL


to uppercase )

LOWER() Converts text =LOWER("EXC excel


to lowercase EL")

PROPER() Capitalizes the =PROPER("exc Excel


first letter of el functions") Functions
words

TRIM() Removes extra =TRIM(" Hello Hello World


spaces World ")

LEN() Counts =LEN("Excel") 5


characters in
text

You might also like