Insert Dash Into ISSN With Leading Zeroes and Text Characters

Hello!

I have a list of tens of thousands of ISSNs and I need to insert a dash between the fourth and fifth characters in each cell. The catch is that some of the ISSNs have 1+ leading zeroes and/or end with a text character ("X"). I've tried several different formulas and a few custom formats to no avail.

Could someone offer guidance on this, please?

Here's an example list of values for the cells in question:

00664146
0927796X
00319333
14761122
00079235


And I need them to look like this:

0066-4146
0927-796X
0031-9333
1476-1122
0007-9235

Non-formula answer (2013 and higher versions)

If the zeros are showing (as questioned by cytop) and your data is in column A
Set column B formatted as text
in B1 enter
0066-4146
then with B2 selected, go to DATA>Flash Fill.
The rest should fill in automatically.

As an alternative formula solution.

	A	B	C
1	00664146	0066-4146	In B2: =REPLACE(A1,5,0,"-")
2	0927796X	0927-796X
3	00319333	0031-9333
4	14761122	1476-1122
5	00079235	0007-9235

But I have to agree with ChemistB. Flash fill is perfect for this.