How to I sort titles alphabetically like in a library?
Thanks - that took care of the one's with "A." But I have one last question:
Now the new titles in column B that started with "The," start with "he." Do
you know why that would happen?
Thanks,
Amanda
"Tevuna" wrote:
1) Type each word on its own row:
C
1 the
2 A
3 of
2) Paste the formula down column B
3) Resort column B
"Amandar097" wrote:
OK - I pasted that formula into column B. Now do I just type The and A into
column C with a space or a comma (The A) or (The, A)?
After that, do I resort column A or column B?
Thanks,
Amanda
"Tevuna" wrote:
Assuming your titles are in column A
1) In column C enter all insignificant words like "the" and "A" etc.
2) Paste this in column B
=IF(ISERROR(VLOOKUP(LEFT(A1,FIND(" ",A1)-1),C:C,1,FALSE)),A1,MID(A1,FIND("
",A1)+1,LEN(A1)))
"Amandar097" wrote:
Hello,
I have a list of movie titles. Some start with "The" and "A". Is it
possible to sort the list alphabetically (like in a library) without using
those words as the primary words by which to sort? If so, how?
Thanks,
Amanda
|