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