Hello
How to leave only letters (element symbols) in a range of cells. The range begins at E1. Each element (Ex. Al240 %) is one cell.
Make this:
<tbody>
</tbody>
Look like this:
<tbody>
</tbody>
Also remove any spaces and the phrase "Calc".
Thanks for any help
Tom
How to leave only letters (element symbols) in a range of cells. The range begins at E1. Each element (Ex. Al240 %) is one cell.
Make this:
Al240% | As189% | B208% | C165% | Ca393% | Co340% | Cr267% | Cu327% | Fe249% | Mn_Calc. | Mo386% | Nb400% | Ni341% | P177% | Pb220% | S180% | Sb206% | Si_Calc. | Sn326% | Ta362% | Ti337% | V411% | W400% | Zr360% |
<tbody>
</tbody>
Look like this:
Al | As | B | Be | C | Ca | Co | Cr | Cu | Fe | La | Mg | Mn | Mo | N! | Nb | Ni | P | Pb | S | Sb | Si | Sn | Ta | Ti | V | W | Zn | Zr |
<tbody>
</tbody>
Also remove any spaces and the phrase "Calc".
Thanks for any help
Tom