How to get this data from a string?

[#1]

Hi,

I was trying to get only the last name and the first name of one employee,

Curtiz, Jinky Lyza,

How to get only Curtiz,Jinky.

Please help..

[christophebrault · Accepted solution]

Hi,

Just use this expression :

=left('Curtiz, Jinky Lyza',index('Curtiz, Jinky Lyza',' ',2))

[#3]

Hi,

its not working.

I have this fieldname.

Employee Name

[#4]

already got the answer. thank you..