Code Conversion

[kunalswami]

I have code similar to as shown in my file.

i have to convert the input code to output code by removing "-" from middle without disturbing other codes from input column.

[DataNath · Accepted solution]

How does this look @kunalswami? If there's a chance that the inputs can be in other formats then we'll need to know so the formula can be adjusted/another approach taken.

[kunalswami]

Thanks DataNath for your support.