concatenation

[Guest]

I need to place a - (hyphen) in a phone number string, i.e., 1234567 to be
123-4567. Any help is appreciated.

 

[Max]

One way ..

Assuming the phone numbers are in A1 down
and are of identical structure (7 digits)

Put in B1=LEFT(A1,3)&"-"&RIGHT(A1,4)
Copy B1 down

 

[nh]

Use function
If cell A1 contains the number
=Left(A1,3)&"-"&mid(a1,4,7)

 

[Debra Dalgleish]

To display the phone numbers with a hyphen, you can use a number format:

Select the cells that contain the phone numbers
Choose Format>Cells
Select the Number tab
Select the Special category
Select Phone number
Click OK