You could create a 'helper' column that has the text sans parens, sort the
two columns together based just on the order of the helper column, then
delete the helper. If the list begins in A2, then in B2 you'd enter the
formula =SUBSTITUTE(SUBSTITUTE(A2,"(",""),")",""). Autofill that through
column B, then sort based on column B.

"baroen" wrote:


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