Hi there I am trying to replace some characters in a Excel and basically what I want is to remove the first two minus signs from a list of numbers, like I show below



Thank you

Hello
perhaps =SUBSTITUTE(SUBSTITUTE(A1;"-";"";1);"-";"";1)
( replace semi-colons with commas if needed)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you very much it worked perfectly

Regards