yogi_Split And Sort List Of Words Into Separate Columns From And To Specified Letters

Google Spreadsheet   Post  #2332

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-29-2017

question by: MChu54321

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/dIpwgKKNcpc;context-place=forum/docs

Splitting range of cells based on first letter of word
Sample sheet with desired output/sample data: https://docs.google.com/spreadsheets/d/1r-ainbtI0ZLmPWR18CP2JvY9VwFZOl7HNAEg5MP4Ru8/edit?usp=sharing

Is there a formula that can be written to do the following?

Input: Unorganized range of cells with word (no numbers) values

Desired output: 2 ranges of alphabetized cells, the first with words starting with A-M, the second starting with N-Z.