In column E, use RIGHT(), LEN(), and FIND() to show the last name of the customer contact (and you again need to embed formulas)

The RIGHT function in Excel returns the specified number of characters from the end of a text string.

The syntax of the RIGHT function is as follows:

RIGHT(text, [num_chars])

Where:

• Text (required) - the text string from which you want to extract characters.
• Num_chars (optional) - the number of characters to extract, starting from the rightmost character.
  • If num_chars is omitted, 1 last character of the string is returned (default).
  • If num_chars is greater than the total number of characters in the string, all characters are returned.
  • If num_chars is a negative number, a Right formula returns the #VALUE! error.

For example, to extract the last 3 characters from the string in cell A2, use this formula:

=RIGHT(A2, 3)