Replace and remove

  • Thread starter Thread starter Kiannie
  • Start date Start date
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 ?
 
This may work for you,

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

Change the range to suit, of course.

HTH
Reagars
Howard
 
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace or Remove 2
Data, Text to Columns, has commas in the text, plus as a delimeter 2
Replace Comma with "-" 2
Replace Comma with "-". 1
How to remove first comma in a value 8
Space removal - a first name,space last name 2
Formatting in formulas not allowed before commas 5
Decimal point in bar chart and similar 1

Back
Top