Text Functions in Microsoft Excel

In this post, you’ll learn about the Text function in Excel, its use-case and how you use it with-in your Excel spreadsheet.

What is a Text Function in Excel?

The TEXT function lets you change the way a number appears by formatting to it with format codes. It’s useful in situations, where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.

The following are some steps on how to use text functions in excel:

  • First, prepare an excel sheet with the required details in it.
Text Functions in Excel
  • To use the text function in excelright-click or press ctrl+1 to get the format cells pane.
  • Now go to the custom option under number pane > type, select an option available there, then copy that by pressing ctrl+c, and then press the cancel button.
Text Functions in Excel
  • Now paste by pressing ctrl+v the copied format code will like this =TEXT(value, “format code”).
  • Remember to have double quotes for format code.
Text Functions in Excel

Here are few examples of other Text related functions in excel

  • LEFT: You can use the left function when you want to extract the leftmost characters from a string. Syntax: =LEFT(text, num_char).
  • RIGHT: You can use the right function when you want to extract the rightmost characters from a string. Syntax: =RIGHT(text, num_char).
  • LEN(): Len function in excel helps you to know the length of a string that is the number of characters in a string. Syntax: =LEN(text).
  • MID(): Mid function in excel is used to extract the characters from the middle of a string. Syntax: =MID(text,start_char,num_char).
  • FIND(): Find function in excel is used when you want to know the position of certain characters in a particular string. Syntax: =FIND(find_text, within_text, [start_num]).
  • SUBSTITUTE(): Substitute function in excel helps to replace existing text with a new text in a particular string. Syntax: =SUBSTITUTE(text, old_text, new_text, instance number).
  • CONCATENATE(): Concatenate function in excel helps to join the text of two or more cells. Syntax: =CONCATENATE(text1, text2… textn).