Thread: Copy data to new cell but with different formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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


Reply With QuoteReply With Quote