Replace First "-" with a blank

[Mark F]

Hi,

I have various part numbers where the first instance of the dash (-) is replaced by a blank...eg Q-1758-25 becomes Q1758-25.

I should be able to do this, but having a moment.

Could someone please help me with the fomula.

Thank for your help
Mark

 

[hajiali]

try

=SUBSTITUTE(C2, "-", "", 1)

 

[Mark F]

Thanks - Perfect