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

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

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

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

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

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

On 25 Oct 2005 14:22:49 -0700, "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

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

--ron