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     www.energyefficientbuild.com.    Mar 27, 2015
question by David Lindamood:
https://productforums.google.com/forum/utm_medium=email&utm_source=ba_notification#!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.
-----------------------------------------------------------------------------------------------------------------------