Solution – Challenge 59 – Clean the Problem Workbook Data

Below is a possible solution to the problem Challenge 59 – Clean the Problem Workbook Data

Formula to convert would be which you need to drag down would be

=–SUBSTITUTE(SUBSTITUTE(A2,UNICHAR(8237),""),UNICHAR(8236),"")

Data has UNICHAR(8237) and UNICHAR(8236) prefixed and suffixed which need to be replaced by above formula.