Inserting Dashes

[Pittman]

In Excel 2007 I have a large spread sheet with 9 digit cell numbers and text
that I need to insert dashes between. Is there a way that I can drag a column
and insert the dashes all at one time.

Current Display: 123XY1234
Display Needed: 123-XY-1234

 

[Bob Phillips]

Use

=LEFT(A1,3)&"-"&MID(A1,4,2)&"-"&RIGHT(A1,3)

and copy down.