I'm trying to figure out how to ignore a parentheses, i.e. (, in an
alphabetical list so the the data is sorted using the first letter
inside the paren. For example; ant, (ape), bear, (bat), etc. is the
correct order but the Excel default sorts the names with parens as
numbers and returns (ape), (bat), ant, bear.
Thanks


--
baroen
------------------------------------------------------------------------
baroen's Profile: http://www.excelforum.com/member.php...o&userid=28824
View this thread: http://www.excelforum.com/showthread...hreadid=485750