Keep whatever keys you might wish to sort on in separate columns.
You can always calculate most full names in another column, rather than
having to re-enter e.g.
=A2&" "&B2
or if say columns A and C are always used but B and D are sometimes
used:
=A2&if(B2=""," "," "&B2&" ")&"C2"&if(D2="",""," "&D2)
You will then be able to sort however you want - e.g. by christian name
within surname, by full bandname, etc. It's likely you'll eventually
regret it if you don't store all usable fields separately.
--
John James
------------------------------------------------------------------------
John James's Profile:
http://www.excelforum.com/member.php...o&userid=32690
View this thread:
http://www.excelforum.com/showthread...hreadid=531829