How do I find a certain symbol in cells?

[sabegirl]

I need to be able to find all cells that have the & symbol. This is a
example of the information in the cells.

1-111
8-89
3-001&CA5-1
3-014&CA5-1

There may be over 500 items in the column and I need to be able to sort
or line up all the cells with the & symbol.

Is there a function or formula that would do this. Thanks for your
help.

 

[Ron Coderre]

See if these give you some ideas:

Using a data list beginning in Cell A10, with A10: MyText

For AutoFilter
Use Custom Filter: Contains &

With Advanced Filter
Criteria:
A1: MyTest
A2: =COUNTIF(A11,"*&*")>0

Or to facilitate standard sorting
B11: =COUNTIF(A11,"*&*")>0
Copy that formula down as far as needed
Sort by Col_B, then by Col_A

Does that help?

Regards,
Ro

 

[Ragdyer]

With data in Column A, one way would be to insert a helper column next to
your column of data, and then enter this formula in the new B1:

=COUNTIF(A1,"*&*")

Double click the fill handle of B1 to copy the formula down Column B, as far
as there is data in column A.

Then select Columns A & B and sort on Column B.

All your "&" cells will now be together at the bottom.