Hi folks,
I used the following script in excel, but the results did not turn out right. I am not sure what is wrong here. Some errors are highlighted. Thank you

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A$2:$A$40,"BA_ICPMS","Barium"),"AL_ICPMS","Aluminium"),"AS_ICPMS","Arsenic"),"CD_ICPMS","Cadmium"),"CL_IC","Chloride"),"CO3","Carbonate"),"COND","Conductivity"),"B","Boron"),"CA","Calcium"),"CR_ICPMS","Chromium"),"CU_ICPMS","Copper"),"F_IC","Flouride"),"FE","Iron"),"HCO3","Bicarbonate"),"HDNESS","Hardness"),"K","Potassium"),"MG","Magnesium"),"MN","Manganese"),"NA","Sodium"),"NO3_IC","Nitrate"),"OH","Hydroxide"),"PALK","Phenol Alkalinity"),"PB_ICPMS","Lead"),"PH","pH"),"SE_ICPMS","Selenium"),"SO4_IC","Sulfate"),"TALK","Total Alkalinity"),"TDS","Total Dissolved Solids"),"U_ICPMS","Uranium"),"ZN_ICPMS","Zinc"),"OPO4","Ortho Phosphorus"),"MO_ICPMS","Molybdenum")

Results (in two separate columns
AL_ICPMS Aluminium
AS_ICPMS Arsenic
B Boron
BA_ICPMS Boronarium
CA Calcium
CD_ICPMS Cadmium
CL_IC Chloride
CO3 Carbonate
COND Conductivity
CR_ICPMS Chromium
CU_ICPMS Copper
F_IC Flouride
FE Iron
HCO3 HCarbonate
HDNESS Hardness
K Potassium
MG Magnesium
MN Manganese
NA Sodium
NO3_IC Nitrate
OH Hydroxide
PALK PALPotassium
PB_ICPMS PBoron_ICPMS
PH pH
SE_ICPMS Selenium
SO4_IC Sulfate
TALK TALPotassium
TDS Total Dissolved Solids
U_ICPMS Uranium
ZN_ICPMS Zinc
CA Calcium
CL_IC Chloride
CO3 Carbonate
COND Conductivity
F_IC Flouride
FE Iron
HCO3 HCarbonate
HDNESS Hardness
K Potassium
MG Magnesium
MN Manganese
NA Sodium
NO3_IC Nitrate
OH Hydroxide
OPO4 Ortho Phosphorus
PALK PALPotassium
PH pH
SO4_IC Sulfate
TALK TALPotassium