| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need cell in A not #VALUE!
-- A B Time to Speak #VALUE! Express Messenger 8,000 Express Messenger Spicegirl Kosmos #VALUE! Buffle Head 12,000 Buffle Head Sea Urchin Hanover #VALUE! Pinstripe Pinup 6,000 Pinstripe Pinup Flanery Hall #VALUE! Bound to be There 8,000 Bound to be There LEFT(C14,FIND(",",C14,1)-3) Is there a way to stop the #VALUE! ISERROR did not work LEFT(ISERROR(C14,FIND(",",C14,1)-3) Thank you Esau |
|
#2
|
|||
|
|||
|
=IF(ISNUMBER(FIND(",",C14,1)-3),LEFT(C14,FIND(",",C14,1)-3),"Whatever")
-- Regards, Peo Sjoblom "Esau" wrote in message ... -- A B Time to Speak #VALUE! Express Messenger 8,000 Express Messenger Spicegirl Kosmos #VALUE! Buffle Head 12,000 Buffle Head Sea Urchin Hanover #VALUE! Pinstripe Pinup 6,000 Pinstripe Pinup Flanery Hall #VALUE! Bound to be There 8,000 Bound to be There LEFT(C14,FIND(",",C14,1)-3) Is there a way to stop the #VALUE! ISERROR did not work LEFT(ISERROR(C14,FIND(",",C14,1)-3) Thank you Esau |
|
#3
|
|||
|
|||
|
Thanks A lot Works great
Esau "Peo Sjoblom" wrote: =IF(ISNUMBER(FIND(",",C14,1)-3),LEFT(C14,FIND(",",C14,1)-3),"Whatever") -- Regards, Peo Sjoblom "Esau" wrote in message ... -- A B Time to Speak #VALUE! Express Messenger 8,000 Express Messenger Spicegirl Kosmos #VALUE! Buffle Head 12,000 Buffle Head Sea Urchin Hanover #VALUE! Pinstripe Pinup 6,000 Pinstripe Pinup Flanery Hall #VALUE! Bound to be There 8,000 Bound to be There LEFT(C14,FIND(",",C14,1)-3) Is there a way to stop the #VALUE! ISERROR did not work LEFT(ISERROR(C14,FIND(",",C14,1)-3) Thank you Esau |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
