You can do a auto filter, then select those comments that you want to delete.
If the data is huge, you might need to do a macro.

"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