Format from 870914143 to 8-709-14143

M

Mary

Hi,
I have a column that I would like to format like the sample below. I want to
keep the dashes between the numbers.
from 870914143 to 8-709-14143
Thank you so much
 
F

Farhad

Hi,

try like below:

A B
1 870914143 =left(A1,1)&"-"&MID(A1,2,3)&"-"&RIGHT(A1,5)
2
3
4
5

then copy the formula in the cell B1 down to where ever you need it is
assumed that all the formats are the same for example if the data in the cell
A2 would be 546537365 the result come up like 5-465-37365 so if you don't
need the column B you can copy column B and pastespecial-value in the column
A and then delete column B.

Thanks,
 
Top