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: 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.