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

 

[Esau]

Thanks A lot Works great

Esau

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


--

Regards,

Peo Sjoblom