{"id":18281,"date":"2016-12-27T16:50:15","date_gmt":"2016-12-27T15:50:15","guid":{"rendered":"https:\/\/jurnsearch.wordpress.com\/?p=18281"},"modified":"2016-12-27T16:50:15","modified_gmt":"2016-12-27T15:50:15","slug":"excel-example-sheet-sort-a-list-to-retain-only-names-and-remove-all-lowercase-words","status":"publish","type":"post","link":"https:\/\/jurn.link\/jurnsearch\/index.php\/2016\/12\/27\/excel-example-sheet-sort-a-list-to-retain-only-names-and-remove-all-lowercase-words\/","title":{"rendered":"Excel example sheet: Sort a list to retain only Names and remove the all-lowercase words"},"content":{"rendered":"

Here’s a working Microsoft Excel 2007 .xlsx file <\/a> (11kb) that has a simple formula to split a word list according to the case of each word’s starting letter. For instance, you have a list that runs…<\/p>\n

Frodo
\nMerry
\nPippin
\nriders
\nGandalf
\nSam
\nponies
\nStrider
\nmushrooms<\/p>\n

You want to remove all the words that do not start with a capital letter, since they are not likely to be personal names or place-names or species etc. Excel can’t do this ‘out of the box’, at least not with the various Sort buttons available in Excel 2007. Nor can plugins like ASAP Utilities. This spreadsheet results in a list with the all-lowercase words pushed down to the bottom of the sorted list, thus…<\/p>\n

Frodo
\nMerry
\nPippin
\nGandalf
\nSam
\nStrider
\nponies
\nriders
\nmushrooms<\/p>\n

It won’t work properly if you also have words in your list with a capital letter after<\/em> the first letter, such as “naZgul”. Those words will be flagged as if they start with a capital letter. Numbers, on the other hand, are fine.<\/p>\n

\"sort_lowercase_excel\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Here’s a working Microsoft Excel 2007 .xlsx file (11kb) that has a simple formula to split a word list according …<\/p>\n

Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-18281","post","type-post","status-publish","format-standard","hentry","category-jurn-tips-and-tricks"],"_links":{"self":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/18281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/comments?post=18281"}],"version-history":[{"count":0,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/posts\/18281\/revisions"}],"wp:attachment":[{"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/media?parent=18281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/categories?post=18281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jurn.link\/jurnsearch\/index.php\/wp-json\/wp\/v2\/tags?post=18281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}