concatenation

M

mo

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

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
 
D

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
 
Top