| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find replace excel remove single character | Excel Discussion (Misc queries) | |||
| remove and replace a digit... | New Users to Excel | |||
| remove and replace digits from a number | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
