Thanks Jacob, but unfortunately the data needs to remain in one column.

"Jacob Skaria" wrote:

Why dont you split that to two columns and then filter. To separate lines to
different columns select data from menu DataText to ColumnsDelimited by
other Ctrl+j and Finish.

If this post helps click Yes
---------------
Jacob Skaria


"Marilyn" wrote:

Hello,

I have an excel table which I often filter. The column that I filter by has
numbers and some of the numbers have a carriage which means some cells have
two lines instead of one and some cells just have one line.

When I perform a Custom filter I choose Custom from the drop down list and
select Contains and type desired number. The problem is that the Contains
criteria only picks up the cells with 2 lines and omits the cells with 1 line
that matches the filter. If I choose Equals then the Equals criteria only
picks up the cells with 1 line and omits the cells with 2 lines.

Example: The numbers with the quotes share one cell.
"6.2
6.7"
"3.4
5.3"
5.2
"1.1
3.3"
3.4

any ideas what can be done in this case?