I need cell in A not #VALUE!

[Esau]

-- 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

[Peo Sjoblom]

=IF(ISNUMBER(FIND(",",C14,1)-3),LEFT(C14,FIND(",",C14,1)-3),"Whatever")


--

Regards,

Peo Sjoblom

"Esau" <[email protected]> wrote in message
news:[email protected]...
>
> -- 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

[Esau]

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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > -- 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
>
>
>