Friday, March 27, 2015

yogi_Split Cells IN Column A On Capitalization

                                           Google Spreadsheet   Post  #1933
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Mar 27, 2015
question by David Lindamood:!category-topic/docs/spreadsheets/GMhjp2kvVMM
Split a cell based on capitilization
I have cell A1 that contains Ca3(PO4)2     I would like to split the string in the cell to : cell B1 = "Ca3", C1 = "(P", D1 = "O4)2".

But I would like it to be able to handle other strings so that it is split  between capital letters (without loosing the capital letters)
I ultimately want to find a count of each element in the chemical formula.  elements in a chemical formula are either a capital letter or a capital and a lower case letter.