How do I find a certain symbol in cells?
 

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.


--
sabegirl
------------------------------------------------------------------------
sabegirl's Profile: http://www.excelforum.com/member.php...o&userid=33982
View this thread: http://www.excelforum.com/showthread...hreadid=537538

How do I find a certain symbol in cells?
 

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,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=537538

How do I find a certain symbol in cells?
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"sabegirl" wrote in
message ...

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.


--
sabegirl
------------------------------------------------------------------------
sabegirl's Profile:
http://www.excelforum.com/member.php...o&userid=33982
View this thread: http://www.excelforum.com/showthread...hreadid=537538