software

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

1-111
8-89
3-001amp;CA5-1
3-014amp;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 amp; symbol.

Is there a function or formula that would do this. Thanks for your
help.--
sabegirl
------------------------------------------------------------------------
sabegirl's Profile: www.excelforum.com/member.php...oamp;userid=33982
View this thread: www.excelforum.com/showthread...hreadid=537538
See if these give you some ideas:

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

For AutoFilter
Use Custom Filter: Contains amp;

With Advanced Filter
Criteria:
A1: MyTest
A2: =COUNTIF(A11,quot;*amp;*quot;)gt;0

Or to facilitate standard sorting
B11: =COUNTIF(A11,quot;*amp;*quot;)gt;0
Copy that formula down as far as needed
Sort by Col_B, then by Col_A

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=537538With 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,quot;*amp;*quot;)

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 amp; B and sort on Column B.

All your quot;amp;quot; cells will now be together at the bottom.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;sabegirlquot; gt; wrote in
message ...
gt;
gt; I need to be able to find all cells that have the amp; symbol. This is a
gt; example of the information in the cells.
gt;
gt; 1-111
gt; 8-89
gt; 3-001amp;CA5-1
gt; 3-014amp;CA5-1
gt;
gt; There may be over 500 items in the column and I need to be able to sort
gt; or line up all the cells with the amp; symbol.
gt;
gt; Is there a function or formula that would do this. Thanks for your
gt; help.
gt;
gt;
gt; --
gt; sabegirl
gt; ------------------------------------------------------------------------
gt; sabegirl's Profile:
www.excelforum.com/member.php...oamp;userid=33982
gt; View this thread: www.excelforum.com/showthread...hreadid=537538
gt;