Hello,
I have these similar written in my excel worksheet. Is there a way to have the Name and Surname only ? It looks like I need a formula would find the " - " and take the rest.
Input
311-31 - AUDREY SURNAME
311-3135 - AUDREY2 SURNAME
Expected Output
AUDREY SURNAME
AUDREY2 SURNAME
Thanks in advance.
Gokhan
I have these similar written in my excel worksheet. Is there a way to have the Name and Surname only ? It looks like I need a formula would find the " - " and take the rest.
Input
311-31 - AUDREY SURNAME
311-3135 - AUDREY2 SURNAME
Expected Output
AUDREY SURNAME
AUDREY2 SURNAME
Thanks in advance.
Gokhan