Hello,
I am relatively new to excel Programming and am trying to figure out the best way to code the below problem. I have a cell which is numbers and text mixed together. It looks something like this.
Cr.15Al2.0V0.5
The goal is to populate a table That is the element above with the amount below.
Cr Al V
0.15 2.0 0.5
I have figured out how to populate the amount Row using the below text. It searches my large string for the element after I manually enter it and returns the three characters following the string. It works for any length elemental abbraviation, so V if fine.
=IF(ISNUMBER(SEARCH(C6,$B3)),VALUE(MID($B3,(FIND(C6,$B3,1)+LEN(C6)),3)),0)
What I would like to be able to do though is just enter the "total string" and have the element symbols populate.
I can't seem to find an elegant way however to just input the string into the "total string" cell and have all the relevant values extracted into their appropriate rows without a second reference to search.
For a more complete set showing of what I am trying to discuss please see the attached workbook.
Bookmarks