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?
Your description and example don't match.
You describe -- 10 digit alphanumeric data; your example shows a single alpha
followed by seven digits.
You describe adding dashes after the 2nd and 6th digits; your example shows
dashes after the 1st and 5th digits.
Given your example, the following will give the result from your source data:
=LEFT(A1,1)&TEXT(MID(A1,2,99),"0-0000-00")
but if your actual data doesn't match your example, you'll have to be more
specific.
--ron