The function TEXTAFTER returns the text string that is after the delimiter character defined.

Syntax:

=Textafter (Text string, delimiter character, instance)

Text string. Text string or cell that contain the text string that wanted to be extracted

delimiter character. is the character that define the separation of what will be extracted

instance. if the delimiter character repeats more than once, this define what number of instance to be considered as the separation of the string.