| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data to new cell but with different formatting
Need to copy data from one cell into another but want the data in a different
format. i.e., cell R77 has 65-1258799 and need to automaticall have Excel put 651258799 in cell T77. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data to new cell but with different formatting
Enter this into Cell T77
=LEFT(R77,2)&RIGHT(R77,8) "chiefwidmer" wrote: Need to copy data from one cell into another but want the data in a different format. i.e., cell R77 has 65-1258799 and need to automaticall have Excel put 651258799 in cell T77. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data to new cell but with different formatting
=SUBSTITUTE(R77,"-","")
-- David Biddulph "chiefwidmer" wrote in message ... Need to copy data from one cell into another but want the data in a different format. i.e., cell R77 has 65-1258799 and need to automaticall have Excel put 651258799 in cell T77. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data to new cell but with different formatting
On Apr 12, 4:26 pm, chiefwidmer
wrote: Need to copy data from one cell into another but want the data in a different format. i.e., cell R77 has 65-1258799 and need to automaticall have Excel put 651258799 in cell T77. Thanks Assuming the dash is always the third character... =REPLACE(B1,3,1,"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy/paste want to retain cell coloration but lose the conditional formatting source data | Excel Discussion (Misc queries) | |||
| copy conditional formatting with 'unique' cell references | Excel Discussion (Misc queries) | |||
| How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| How do I copy formatting in a cell reference | Excel Discussion (Misc queries) | |||
Linear Mode
