First, there are no formulas that delete rows.

Second, do you really mean comments (like Insert|Comment stuff) or do you mean
values in the cell?

If you really meant comments, then you'll have to use code to inspect those
comments.

But if you meant values, you could:
Insert a new column B
Add headers to row 1 if you don't have them.
Put this in B2:
=or(a2={"be","ie","at"})

Now drag this down as far as you need.

Apply data|filter|autofilter to column B.
Show the Rows that have TRUE in column B.
Delete those visible rows.
Remove the filter (data|filter)
delete column B
Delete the header row if you added it.



Radhakant Panigrahi wrote:

Hi,

i need to delete the rows where the comment in the column A contains some
charaters...for example below are the comment in column A...and i need to
delete the rows where the comment in column A is BE, IE and AT. Is there any
formula by which the rows with BE, IE and AT in column A can be deleted...

DE
DE
IT
IT
PT
PT
IE
BE
IT
BE
AT

rgds
radha

--

Dave Peterson