Hello, I've a sheet in which a column is a string that represents a number but includes some punctuation (,.). How can I remove these characters in order to convert it to a number and then be able to calculate the average.
I've tried CHANGESTRINGTOINTEGER but with those characters is not working.
The REPLACE function seems the solution but I don't understand the parameters...
This topic has been locked.