ExcelBanter - Replace and remove

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Replace and remove (https://www.excelbanter.com/excel-discussion-misc-queries/224690-re-replace-remove.html)

L. Howard Kittle

Replace and remove

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 ?

L. Howard Kittle

Replace and remove

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 ?

All times are GMT +1. The time now is 04:49 PM.