format problem

V

vikram

I have a file of 50000 rows and in column A in just 2 or three cells
i have a cell which show #NAME? but if u click that cell it will sho
=- vikram, how to get rid of this cell...i mean to say that how t
format that cell to a eadable format

thank
 
K

Ken Wright

Nothing wrong with the format (at least I don't think so), you just don't have a
named range or value of vikram.
 
L

Lady Layla

Either assign a range or value to vikram or do a find =-vikram replace (blank
or 0 or whatever you want to show there) Replace all

: but i want to get rid of cells which show #NAME? this value
: how to do that
:
:
: ---
:
:
 
Top