Sunday, March 10, 2013

yogi_Sort a List Of Phrases In Column A Ignoring Leading Articles The An A

                                          Google Spreadsheet   Post  #1076
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Mar 10, 2013
user Mark RJ Williams :(!category-topic/docs/spreadsheets/M9RAysy5bsw)
How do I sort a spreadsheet alphabetically, but ignoring leading articles (the, a, an)
I'd like to auto sort a spreadsheet according to the value of an alphabetic column (in a-z order, ignoring case).
Obviously this in itself is rather simple, but I'd like to ignore leading articles (the, an, a) when ordering.

For example, "The House Next Door" should be with the H entries etc.

Many thanks.

in the following I have assumed that the phrase in column A begins with an UPPER case letter (well more specifically the leading article is in PROPER case)