Identification of "<" character at beginning of cell
 

Hi,

I have an excel column in which I have some values starting with the symbol
"<". say "<x". The other cells have normal values like x. x can be any
number. These values come from a machine.

Now, I want to eliminate all cells/rows in that sheet that have values
starting with the "<" symbol. Is there any way I can do this with the built
in functions/formulae of excel ? Any ideas are appreciated.

Thanks,
Hemil.

Hi!

You can do this with a filter.

Select the column in question.

Goto DataFilterAutoFilter

From the drop down select Custom.
In the user form that opens, in the first drop down select Begins With
In the box beside that enter <
OK

Now you can select all the visible cells from the filtered list and delete
the entire row(s) if that's what you want to do.

After you're done doing that GotoDataAutoFilter to get rid of the filter.

Biff

"Hemil" wrote in message
...
Hi,

I have an excel column in which I have some values starting with the
symbol
"<". say "<x". The other cells have normal values like x. x can be any
number. These values come from a machine.

Now, I want to eliminate all cells/rows in that sheet that have values
starting with the "<" symbol. Is there any way I can do this with the
built
in functions/formulae of excel ? Any ideas are appreciated.

Thanks,
Hemil.

Thanks Biff.

"Biff" wrote:

Hi!

You can do this with a filter.

Select the column in question.

Goto DataFilterAutoFilter

From the drop down select Custom.
In the user form that opens, in the first drop down select Begins With
In the box beside that enter <
OK

Now you can select all the visible cells from the filtered list and delete
the entire row(s) if that's what you want to do.

After you're done doing that GotoDataAutoFilter to get rid of the filter.

Biff

"Hemil" wrote in message
...
Hi,

I have an excel column in which I have some values starting with the
symbol
"<". say "<x". The other cells have normal values like x. x can be any
number. These values come from a machine.

Now, I want to eliminate all cells/rows in that sheet that have values
starting with the "<" symbol. Is there any way I can do this with the
built
in functions/formulae of excel ? Any ideas are appreciated.

Thanks,
Hemil.

You're welcome! Thanks for the feedback.

Biff

"Hemil" wrote in message
...
Thanks Biff.

"Biff" wrote:

Hi!

You can do this with a filter.

Select the column in question.

Goto DataFilterAutoFilter

From the drop down select Custom.
In the user form that opens, in the first drop down select Begins With
In the box beside that enter <
OK

Now you can select all the visible cells from the filtered list and
delete
the entire row(s) if that's what you want to do.

After you're done doing that GotoDataAutoFilter to get rid of the
filter.

Biff

"Hemil" wrote in message
...
Hi,

I have an excel column in which I have some values starting with the
symbol
"<". say "<x". The other cells have normal values like x. x can be any
number. These values come from a machine.

Now, I want to eliminate all cells/rows in that sheet that have values
starting with the "<" symbol. Is there any way I can do this with the
built
in functions/formulae of excel ? Any ideas are appreciated.

Thanks,
Hemil.