Friday, December 29, 2017

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
Splitting range of cells based on first letter of word
Sample sheet with desired output/sample data:

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.