Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More

© Mandeep Mehta 2021

M. MehtaMicrosoft Excel Functions Quick Referencehttps://doi.org/10.1007/978-1-4842-6613-7_2

2. Text Functions

Mandeep Mehta¹  

(1)

Mumbai, India

 

In this chapter, we will look into the text functions provided by Excel.

Note

In the text functions in this chapter, the argument text can be

• a literal text string value enclosed in double quotes (“ ”),

• an Excel function returning a text string,

• a cell reference where the cell contains a text string, or

• a named range containing a text string.

Let us begin exploring the text functions.

LEFT Function

This function returns characters from the left side of a text string.

Syntax

=LEFT(text, CharCount)

This function takes the following arguments:

• The first argument is the text string from which characters ...