I have a column of data that contains a 7 digit number in each row. I need to insert a hyphen after the 2nd number for formatting purposes. Any easy way to do it? I am getting tired of the copy and paste. Example below

As it looks now:
990000
990001

How I need it to look:
99-0000
99-0001

Thanks.

If it is for formnatting purposes then Custom format the cells as:

##-#####

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Mark31" wrote in message
...

I have a column of data that contains a 7 digit number in each row. I
need to insert a hyphen after the 2nd number for formatting purposes.
Any easy way to do it? I am getting tired of the copy and paste.
Example below

As it looks now:
990000
990001

How I need it to look:
99-0000
99-0001

Thanks.




--
Mark31

Try =LEFT(A1,2)&"-"& RIGHT(A1,4) copy down as far as needed.

Then copy - paste special - values to get rid of the formulas

HTH
Regards,
Howard

"Mark31" wrote in message
...

I have a column of data that contains a 7 digit number in each row. I
need to insert a hyphen after the 2nd number for formatting purposes.
Any easy way to do it? I am getting tired of the copy and paste.
Example below

As it looks now:
990000
990001

How I need it to look:
99-0000
99-0001

Thanks.




--
Mark31

Just create a new numerical format 00-0000.

"Mark31" schreef in bericht
...

I have a column of data that contains a 7 digit number in each row. I
need to insert a hyphen after the 2nd number for formatting purposes.
Any easy way to do it? I am getting tired of the copy and paste.
Example below

As it looks now:
990000
990001

How I need it to look:
99-0000
99-0001

Thanks.




--
Mark31

A Custom Format that looks something like 00-#### should do what you want.

Select your column, right-click and select Format Cells. The first tab is
"Number". Custom is at the bottom of the left-hand list.
HTH

Thanks a lot, your replies were very helpful!