Thread: Copy data to new cell but with different formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default 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
Reply With QuoteReply With Quote