Instead of Dash Number Use ()

[Legacy 436357]

Hello,

I have a very long list of part numbers that I would like to summarize without the dash numbers.

I would like to add "-()" to the end of the first part of the numbers like:

1D937K-1524879 becomes 1D937K-()
52D77-4 becomes 52D77-()
528-58-9999 becomes 528-()

Is there a way to do this please? There is no set number of digits.

Thank you very much for your help,
XJ

PS If there is no dash in the number it needs to stay as is.

Thanks

 

[Fluff]

how about
=left(A1,find("-",A1))&"()"

 

[Legacy 436357]

Thanks but I get a #value ! error when there are no dashes.

 

[Trevor_S]

If the original number is in cell A1, use this:
=IFERROR(LEFT(A1,FIND("-",A1))&"()",A1)

This finds the hyphen, discards the remainder and adds the brackets to the end. But if there's no hyphen, the FIND function results in an error, which is trapped and the full value of A1 is returned.

 

[Legacy 436357]

Thank you Trevor that is perfect! Also thank you Fluff for helping too!

 

[Scott Huish]

You can also just make sure that FIND doesn't fail. I did add an IF though in case the cell was blank:
=IF(A1="","",LEFT(A1,FIND("-",A1&"-")-1)&"-()")