add - to cell data

Chimp8471 · #1 (**permalink**) 06-23-10, 11:28

i have a 10 digit value in my cell which i need to change to match the following:

now

1234567890

required

1-234-56-789-0

with the dashes always being in after the:

1st, 4th, 6th and 9th numbers

please advise

Colin Legg · #2 (**permalink**) 06-23-10, 11:58

Hi,

If it is just for display purposes, format the cell with this custom type:
#-###-##-###-#

If you really need to have the hyphens within the value then you could use a formula such as:

Code:

=LEFT(A1)&"-"&MID(A1,2,3)&"-"&MID(A1,5,2)&"-"&MID(A1,7,3)&"-"&RIGHT(A1)

Hope that helps...

Chimp8471 · #3 (**permalink**) 06-23-10, 12:56

ok it's nearly there, with the above formula i get

7-483-3-44-7

from

7483440017

i am loosing a few digits

I need

7-483-44-001-7

Any ideas?

Colin Legg · #4 (**permalink**) 06-23-10, 13:01

The formula I posted works absolutely fine for me. Example attached.

Chimp8471 · #5 (**permalink**) 06-23-10, 13:21

ok it seems to be a formatting issue, thanks for your help

Internet Services

Web Development

Digital Marketing

Consumer Tech