Get End of expression expected error when write cell with formula

Hi,

Can you try the following?

"=IF(ISNUMBER(SERACH(""-2146826246"",J2)),K2,J2)"

Note: Doublequote should be expressed as "" in String literal (VB.net)

Regards,

1 Like