Simple question- please help!

M

Mark31

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.
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
L

L. Howard Kittle

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
 
M

Minx

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
 
Top