How can I replace #VALUE! with a blanck cell?

[Motox]

Hi forum,

I have a formula in cell A4 that gets a value from cell C4 if the value in C4 is followed by a comma (i.e. it gets the first value in a series of values seperated by commas).
The formula is =LEFT(C4,(FIND(",",C4,1))-1)
It works well but if there is no value in cell C4 then I get #VALUE! in cell A4.

What I need is for cell A4 to remain "blank" if there is no value in cell C4.

I have tried using IF combined with ISERROR but can not get it to work.

Can anyone help?

Thanks very much

Motox

[daddylonglegs]

Try this version

=LEFT(C4,FIND(",",C4&",")-1)