Topic
No replies
SystemAdmin
SystemAdmin
603 Posts
ACCEPTED ANSWER

Pinned topic BigSheets replacing characters in a string

‏2013-03-23T18:57:02Z |
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...

Thanks