Error Message in cell, replace with...

[ilcaa]

Hi,

I have a data feed that comes into Excel and I have some cells with formulas that untill i input a Symbol in a certain column it gives me an error message InvalidSymbol, obviously the formula doesnt have anything to reference

How can I change that to just a blank cell or with something else....thanks

 

[Aladin Akyurek]

If A2 is supposed to house a number...

=IF(ISNUMBER(A2),A2,"")

If text is expected...

=IF(ISTEXT(A2),A2,"")

 

[ilcaa]

i need to format the whole worksheet with this formula most house numbers and column A houses Text....

do I go to view code and create a sub for the entire worksheet?

not usre how to implement your solution into my entire worksheet.

thanks

 

[stanleydgromjr]

Can you show us the formulas?


Have a great day,
Stan

 

[pgc01]

Hi ilcaa

There is an easy way to hide the warnings using conditional formatting.

Select the range where this happens

Format>Conditional Formatting

In Condition 1:

Cell Value equal to ="InvalidSymbol"

click Format and in the Font tab choose the font colour white.

Click OK OK

The message is still there but you don't see it.

Hope this helps
PGC