| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to add dashes in a cell which has both number and tex
=LEFT(A1,4)&"-"&MID(A1,5,4)&"-"&MID(A1,9,4)&"-"&RIGHT(A1,4)
"shafali" wrote: I want to add dashes in a cell which has both number and text. for example, a cell contaion 10G101211100011 and i want to change it to 100G-1012-1110-0011. Is there a formula i can use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to put dashes in a number 13000000000 to 1300-000-0000 | Excel Discussion (Misc queries) | |||
| How do I delete dashes from a phone number xxx-xxx-xxxx in Excel? | Excel Worksheet Functions | |||
| Removing dashes from ISBN's while still keeping 1st number (zero) | Excel Worksheet Functions | |||
| removing dashes changes test into number | Excel Discussion (Misc queries) | |||
| How do I format a social security number to have no dashes? | Excel Discussion (Misc queries) | |||
Hybrid Mode
