View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aries68mc aries68mc is offline
external usenet poster
 
Posts: 3
Default How do I delete merged cells in Excel without deleting the final d

I have a column of dates that was formatted YY/MM/DD that I wanted formatted
MM/DD/YY. I split the cells then recombined the 3 new columns into a 4th
using the concatenate function. How do I delete the 3 columns without
deleting the combined data in the 4th?

Thanks,
Mary