TEXTAFTER Function Explained

The TEXTAFTER function in Microsoft Excel returns the characters that appear after a specified character or text string in a text string. It takes two arguments: text (the text string to search) and find_text (the character or text string to search for). It returns the characters that appear after the specified character or text string in the text string.

TEXTAFTER Function Syntax

TEXTAFTER(text, start_num, num_chars)

  • text: The text string from which you want to extract a substring.
  • start_num: The position of the character in the text string from which you want to start extracting the substring.
  • num_chars: The number of characters you want to extract from the text string.