Download the the workbook from the below link. The Challenge before you is to write a formula to clean the data. If you perform any mathematical operation on the data, it will return #VALUE error. You need to clean the data through a formula.
Challenge 59 – Problem Workbook
The solution to the above problem will be posted after a month i.e. on 4-Mar-17.
Excel 2016 Italy I have problems with commas,
Here's the formula in B2
=–SOSTITUISCI(STRINGA.ESTRAI(A2;2;LUNGHEZZA(A2)-2);".";",")