title: How to fix #NAME? error with formula or vba
body: <p>i am using an excel formula to reference, and adjust when necessary, a very long list of scraped values. my problem is that occasionally the values start with "=+" causing them to be seen as a formula, and thus producing a #NAME? error. whenever my formula references these cells, it too produces said error.</p>
  
  <p>is there anyway to account for #NAME errors within my formula? something like ISNA but for #NAME errors?</p>
  
  <p>if that is not possible, could i use VBA to delete "=+" from any cells that contain it?</p>
  
  <p>any help would be greatly appreciated, ive been looking for an answer to this for hours.</p>