Deleting Text

[Jose Luiz]

Is it possible to write a function that deletes text within
a range of selected cells?? I have a worksheet where some of the cells have
include text that I typed in and some cells have just numerical data. Is it
possible, for a certain range of cells, to clear the data out of all cells
that include text and in general is it possible to write a function that
clears the text in a cell if the data inside the cell meets a certain
condition?? Any help would be much appreciated!!!

Maria

 

[Biff]

Hi Maria,

That is not possible using a function. You could do this:
Select the range of cells that you want to delete the text
entries from but this does not mean just each individual
cell that contains text. It is the entire range that would
include both text and numeric entries. Select the entire
range. Hit F5 function key. Click on Special. Select
Constants. Under the Formulas selection check only the
Text entry. Make sure all other entries are not selected.
Then click OK. All the text entries in the range should
now be selected. Then just delete.

You could record a macro to do this and make it that much
easier.

Biff