Replace and remove

K

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

L. Howard Kittle

This may work for you,

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

Change the range to suit, of course.

HTH
Reagars
Howard
 
L

L. Howard Kittle

That should be REGARDS of course

L. Howard Kittle said:
This may work for you,

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

Change the range to suit, of course.

HTH
Reagars
Howard
 
Top