Error #Value!

Hi

Can someone please help me with this formula, it is working as i need it to, its just that i am getting #value! in column when rows are blank, can someone edit formula to ignore blank cells please.

=VALUE(LEFT(B2,SEARCH("-",B2)-1))

=iferror(value(left(b2,search("-",b2)-1)),"")

or

=if(b2="","",value(left(b2,search("-",b2)-1)))

Your a star Thank you

No probs. Happy to help.