Forum Discussion
Trying to use SUBSTITUTE to exchange a character, and gets VALUE ERROR
I have a column in my spreadsheet that have values with DOT instead of COMMA-sign. I created a public function like this: Public Function fixakomma(rng As String) fixacomma = SUBSTITUT...
DouglasJB Did you consider "Find & Replace" or "Text-to-columns"? Is there a particular reason why you want to use a User Defined Function, just to substitute a point for a comma?