converting non numerical cells to blank cells

K

K. Georgiadis

What function (or formula) can I use to convert cells
that contain non numerical characters (e.g., text such
as "not applicable" or "not rated") into blank cells?
 
P

Peo Sjoblom

if indeed they are text and the other cells are numeric numbers that excel
see as numbers
select the range, press F5, select constants and make sure only text in
checked, press enter,
press the delete button

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
B

bj

if column A has your information
insert new column B and enter
=IF(ISNUMBER(A1),A1,"")
in cell B1
You can then copy column B and paste value over column A
and delete Column B to have the original worksheet
without the text.
 
Top