Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a leader from the end of text to the end of a cel. | Excel Discussion (Misc queries) | |||
How do I insert a clip art picture into a text box in word 2003 | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Retriveing a text from one sheet and insert to another | Excel Worksheet Functions | |||
Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) |