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