I have two types of values in a column. One that contains a value with a dot
(GB2-E0031.02) and one that does not contain a value with a dot (GB2-E0031) I
would like to delete the whole row If the value in column B does not contain
a dot (.)

Many thanks in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200605/1

1) Select the column
2) Go to menu data/filter/auto filter
3) In the dropdown list of criteria, select custom...
4) In the criteria setup, select "Contains" and type "." as value
5) This will show only those rows which "."
6) Delete these rows (after filtered)
7) Go to menu data/filter/auto filter to remove filter.

--
Best regards,
---
Yongjun CHEN

=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================


"mohd21uk via OfficeKB.com" <u20517@uwe> wrote in message
news:5ffe679adbffb@uwe...
>I have two types of values in a column. One that contains a value with a
>dot
> (GB2-E0031.02) and one that does not contain a value with a dot
> (GB2-E0031) I
> would like to delete the whole row If the value in column B does not
> contain
> a dot (.)
>
> Many thanks in advance.
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...l-new/200605/1