View Single Post
  #2   Report Post  
Elkar
 
Posts: n/a
Default 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