Return the product name and number, making sure to remove any extra characters.

C:$-$ Type in the correct formula

$\backslash$table$[[,{?}_{\text{P}\text{r}\text{o}\text{d}\text{u}\text{c}\text{t}\text{C}\text{o}\text{d}\text{e}}^P,$Formula,$],[1,$ACK$-12.$West, $\text{'},$ a$1),9999),$ACK$-12.$West$],[2,$ACK$-138.$South,$=$ MID $($a$2,$ SEARCH$("$A$",$ a$2),9999),$ACK$-138.$South$],[3,$AC$-13.$North,, SEARCH$("$A$",$ a$3),9999),$AC$-13.$North$],[4,$A$-1.$East,, SEARCH$("$A$",$ a$4),9999),$A$-1.$East$]]$