View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
eat more bacon eat more bacon is offline
external usenet poster
 
Posts: 1
Default Text to Columns Error

I copied a table from Access into Excel and then took one of the columns,
which contains URLs and parsed it using the Text to Columns feature, so I
could easily separate the piece of the URL I needed. No problem there.

Now, however, I am copying a different table from Access into Excel. This
table is to remain as is. However, for some reason Excel is automatically
parsing this table when I paste it into Excel. This happens whether on the
same worksheet, a different one, or even if I try a different workbook. For
some reason, the 'text to column' feature seems to be automatically enabled,
even though i no longer want it.

I've never seen this behavior before and not sure how to end it.

Thanks,
Allan