Replace or 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 test after the comma ?

 

[Stefi]

One way:
=LEFT(A1,SEARCH(",",A1)-1)

Regards,
Stefi

„Kiannie†ezt írta:

 

[MVP]

Another method, assuming all the text is in a single cell (or column) is to
use the "text to columns" tool in the data category. When you open the tool,
select "delimited" and then "next". Click on the comma delimiter and then
"next". The text will be broken into two (or more) columns at the comma(s).
Select the format of the column you want to keep (general, text, etc.). For
the data you want to drop, select the "do not import column" option.