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

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

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

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,"")