Frequently Used String Functions in Excel

String functions/formulas plays major roll in Excel when working with large number of records. The most frequently used string functions in Excel are listed below.

Left

Right

Mid

Left Function

Returns a specified number of characters from the left side of a string.

The syntax for the Left function is

=LEFT (string, number of characters)

Where

String is the text you want to manipulate

Number of characters indicates the number of characters you want to extract starting from the left-most character.

Example:

=LEFT (“Example”, 1) – Extract First letter from the string “Example” i.e. “E”

Right Function

Returns a specified number of characters from the right side of a string.

The syntax for the Right function is

=RIGHT(string, number of characters)

Where

String is the text you want to manipulate

Number of characters indicates the number of characters you want to extract starting from the right-most character.

Example:

=RIGHT(“Examples”, 1) – Extract last letter from the string “Examples” i.e. “s”

Mid Function

Mid function is simply same as the LEFT & RIGHT function where here we are going to specify the starting index and number of character to extract.

The syntax for the MID function is

=MID (string, Start position, Length)

Where

String is the text you want to manipulate

Start position is the position of the first character you want to extract. Note: The first character in text is 1.

Length specifies how many character you want to extract.

Example:

=MID (“Examples”, 3,2) – Extract 3rd and 4th character from the string “Examples” i.e. “am”

String Manipulation

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>