| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula
I have cells where I am trying to eliminate text after the dash, but it gives
me errors if the cells does not contain a dash. How can I have it just give me what is in the cell if no dash is found? For example (the first one gives it to me correctly, but the second one finds an error) NL RISON KANTOOR ITEMS-SCHAGEN NL RISON KANTOOR ITEMS NL PEJO ELECTROSERVICE B V #VALUE! My formula reads =TRIM(LEFT(B2,FIND("-",B2)-1)) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula
=IF(ISERR(FIND("-",B2)),B2,LEFT(B2,FIND("-",B2)-1))
-- Don Guillett Microsoft MVP Excel SalesAid Software "Cassius" wrote in message ... I have cells where I am trying to eliminate text after the dash, but it gives me errors if the cells does not contain a dash. How can I have it just give me what is in the cell if no dash is found? For example (the first one gives it to me correctly, but the second one finds an error) NL RISON KANTOOR ITEMS-SCHAGEN NL RISON KANTOOR ITEMS NL PEJO ELECTROSERVICE B V #VALUE! My formula reads =TRIM(LEFT(B2,FIND("-",B2)-1)) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula
Try this:
=LEFT(B2,FIND("-",B2&"-")-1) -- Biff Microsoft Excel MVP "Cassius" wrote in message ... I have cells where I am trying to eliminate text after the dash, but it gives me errors if the cells does not contain a dash. How can I have it just give me what is in the cell if no dash is found? For example (the first one gives it to me correctly, but the second one finds an error) NL RISON KANTOOR ITEMS-SCHAGEN NL RISON KANTOOR ITEMS NL PEJO ELECTROSERVICE B V #VALUE! My formula reads =TRIM(LEFT(B2,FIND("-",B2)-1)) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula
Hi Biff,
Jumping in. Very cool! Regards - Dave. "T. Valko" wrote: Try this: =LEFT(B2,FIND("-",B2&"-")-1) -- Biff Microsoft Excel MVP |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula
Agreed
-- Don Guillett Microsoft MVP Excel SalesAid Software "Dave" wrote in message ... Hi Biff, Jumping in. Very cool! Regards - Dave. "T. Valko" wrote: Try this: =LEFT(B2,FIND("-",B2&"-")-1) -- Biff Microsoft Excel MVP |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula
Thanks!
-- Biff Microsoft Excel MVP "Don Guillett" wrote in message ... Agreed -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave" wrote in message ... Hi Biff, Jumping in. Very cool! Regards - Dave. "T. Valko" wrote: Try this: =LEFT(B2,FIND("-",B2&"-")-1) -- Biff Microsoft Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
