I copy data from a web page and paste it into a table. Then in other
tables I do some calculations.

For example I have this formula:

=IF($F$1="","",(0.5*(B4*($F$1+1)*3)-1))

The problem is that cell F1 refers to a text string that looks like
three tiny dashes - - -

Now, in my new table I get the value error. I need to get rid of this
value error so I can do other calculations. One of which is to rank
some columns but that won't work with the #VALUE! in there.

Thanks