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