Replace and remove

[Kiannie]

I want to remove all text after the comma,

example :

abc, fjosjfojf
cake, lkd;lkdfdl;kfd
food, fkfjuwrasndasm

How to remove all the text after the comma ?

 

[L. Howard Kittle]

This may work for you,

=LEFT(F1,FIND(",",F1)-1)

Change the range to suit, of course.

HTH
Reagars
Howard

 

[L. Howard Kittle]

That should be REGARDS of course

This may work for you,

=LEFT(F1,FIND(",",F1)-1)

Change the range to suit, of course.

HTH
Reagars
Howard