Insert "-" in text "1234567890" to have a output like this"123-456-7890"

This is a very simple requirement. Can anyone help me with this ASAP.

What i need:- Insert "-" in text "1234567890" to have a output like
this"123-456-7890"

Thanks in advance!!!

Regards,

Alwyn

Change the format of the cells to "Custom" and enter 000-000-0000

"Alwyn" wrote:

> This is a very simple requirement. Can anyone help me with this ASAP.
>
> What i need:- Insert "-" in text "1234567890" to have a output like
> this"123-456-7890"
>
> Thanks in advance!!!
>
> Regards,
>
> Alwyn
>
>

That is the easiest solution to change the output of the cells. If you want
to actually change the content of the cells you will need to create a dummy
column and use the formula

=LEFT(A1,3)&"-"&MID(A1,3,3)&"-"&RIGHT(A1,4)

After copying this formula down the list, you can then copy the column and
paste special selecting "values".


"Elkar" wrote:

> Change the format of the cells to "Custom" and enter 000-000-0000
>
> "Alwyn" wrote:
>
> > This is a very simple requirement. Can anyone help me with this ASAP.
> >
> > What i need:- Insert "-" in text "1234567890" to have a output like
> > this"123-456-7890"
> >
> > Thanks in advance!!!
> >
> > Regards,
> >
> > Alwyn
> >
> >

On 25 Oct 2005 14:22:49 -0700, "Alwyn" <[email protected]> wrote:

>This is a very simple requirement. Can anyone help me with this ASAP.
>
>What i need:- Insert "-" in text "1234567890" to have a output like
>this"123-456-7890"
>
>Thanks in advance!!!
>
>Regards,
>
>Alwyn

=TEXT(1234567890,"000-000-0000")

--ron