I’m trying to figure on how to remove the numerical reference after a special characters. See below for an example:
The original text is H & S Issue therefore i’d like to have the ‘#38;’ removed when capturing the value from that particular column. Below is the excel file.
KaiNexus-Export-06042020-223456.xlsx (11.5 KB)
Would definitely appreciate for any help.