How to insert multiple characters in middle of cell data

[horizont]

I need to insert two "-" into a column of cells in different locations within the same number. What is the best way to do this?
I have figured out how to get one of the hyphens in using the formula =REPLACE(A2,7,0,"-") but I can't figure out how to get the second hyphen in.

Example:
Existing information in cell:
123456789

Needs to be:
123456-78-9

Thanks for all you help!

 

[6StringJazzer]

Is the data always 9 characters?

=LEFT(A2,6) & "-" & MID(A2,7,2) & "-" & RIGHT(A2,1)

 

[Fluff]

Another option

=REPLACE(REPLACE(A2,9,0,"-"),7,0,"-")

 

[horizont]

Is the data always 9 characters?

=LEFT(A2,6) & "-" & MID(A2,7,2) & "-" & RIGHT(A2,1)

Thanks you! This is exactly what I needed!

 

[horizont]

Another option

=REPLACE(REPLACE(A2,9,0,"-"),7,0,"-")

Thank you! this worked great too! Good to have options!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[6StringJazzer]

Another option

=REPLACE(REPLACE(A2,9,0,"-"),7,0,"-")

I like this better than mine. Did not realize you can use 0 in REPLACE.