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