Insert hyphens in number or letter strings

Is there a formula similar to the "Replace" one that could insert hyphens in a serie of numbers.
Explain: I acquire data from a site on the Internet in the format of a spreadsheet. Columns are filled with strings of numbers and or characters like:11001446521. I need to change it to 110-0144652-1.
Is there a formula that can perform this change?

TKS

Originally Posted by NBVC

If your data is consistent and the results you want are consistent (i.e. the dashes are always in the same places), then try:

=LEFT(A2,3)&"-"&MID(A2,4,7)&"-"&RIGHT(A2)

where A2 contains string to convert. Then copy formula down.

[QUOTE=excelhlp]Works fine as long as you finish with (A2,2). Want to thank the issuer of the reply. Without help I couldn't have finished writing the formula.