Inserting Dashes
 

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
--
Marcus

Inserting Dashes
 

Use

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

and copy down.

--
__________________________________
HTH

Bob

"Pittman" wrote in message
...
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
--
Marcus