Sorting
On 11/8/2007 9:19 AM, Peo Sjoblom went clickity clack on the keyboard
and produced this interesting bit of text:
No, you would need a help column that will remove these characters
if the list starts in A2 you can use this in B2
=IF(LEFT(A2,4)="The ",SUBSTITUTE(A2,LEFT(A2,4),""),IF(LEFT(A2,2)=" A
",SUBSTITUTE(A2,LEFT(A2,2),""),A2))
copy down as long as needed and sort by the help column
the above will take care of A and The
Thank you muchly!
--
You, you, and you panic. The rest of you, come with me.
|