Try this:

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

I assume you mean you are starting with 8 digit data and want it to
become 10 digit (characters).

Hope this helps.

Pete

On Apr 28, 1:36*pm, Dr. S <Dr. wrote:
Having a column with 10 digit alphanumeric data (ie H1187600) I need to add
dashes after the 2nd and the 6th digit to look like H1-1876-00.
Shouldn't be difficult?