That should be REGARDS of course

"L. Howard Kittle" wrote in message
...
This may work for you,

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

Change the range to suit, of course.

HTH
Reagars
Howard

"Kiannie" wrote in message
...
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 ?