Need Right Formula

[Basavaraj K H]

Dear Team

Kindly Refer attached file.

& I need last name or operators name as per attachment (same like row 3)


Thanks in Advance

Regards
Basavaraj K H

 

[tomas]

Hi

find attached

 

[Khalid NGO]

Hi Basavaraj,

Try this:

=TRIM(MID(A1,FIND("-",A1)+1,99))

Regards,

 

[Deepak]

One more

=TRIM(REPLACE(A1,1,FIND("-",A1),""))