Remove text with REPLACE/FIND

[russkris]

Hi Gang,

Not sure if I am googling the right function.

I have 1 one that name "Lastname, FirstName PRID 12345"

Just wondering how I remove any text after the first name.

[FDibbins]

If your data is in Q27
=LEFT(Q27,FIND("@",SUBSTITUTE(Q27," ","@",2))-1)

[russkris]

Awesome, thank you very very much

[FDibbins]

happy to help and thanks for the feedback