I have a formula to change Financial products into a different format but it isn't working on data with a Hypon/-
Examples:
CME E-MINI RUSSELL 2000 INDEX JUN21
NASDAQ100 Micro JUN21
E-MICRO COMEX Gold JUN21
It will change the dates to CQG dates, remove spaces and change the Product e.g. to NASDAQ100 Micro to desired sybmol i.e "MNQ". However, for the products with "-" it doesn't seem to work. Please help, file and photo attached