I have a list of text (part numbers) such as 704A34101006 which I want to re format with dashes included i.e 704A34-1010-06, is there a simple way to do this for a large number of cells at once, they are all in the format without the dashes and I want to keep the same digits but in the fornat with dashes
Any help would be much appreciatted
Any help would be much appreciatted