View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Paste cells without tabs

I want to copy the contents of two horizotally adjacent cells, and paste the
contents to rename a file in Windows Explorer. However, the clipboard
retains a tab character between the text in the cells.

How can I copy and paste the cells as run-on text, without a tab character
in between? (I want to avoid, if possible, creating a third column to
concatenate the two cells.)