Identification of "<" character at beginning of cell

[Guest]

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.

 

[Biff]

Hi!

You can do this with a filter.

Select the column in question.

Goto Data>Filter>AutoFilter

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 Goto>Data>AutoFilter to get rid of the filter.

Biff

 

[Guest]

Thanks Biff.

Hi!

You can do this with a filter.

Select the column in question.

Goto Data>Filter>AutoFilter

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 Goto>Data>AutoFilter to get rid of the filter.

Biff

 

[Biff]

You're welcome! Thanks for the feedback.

Biff

Thanks Biff.