How can I clear the last Data->Text to columns to formatting

  • Thread starter Thread starter svaardt
  • Start date Start date
S

svaardt

I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?

Thanks


Steve
 
Just run another data|Text to columns against a dummy cell.

Specify delimited, but remove all the check marks from all the possible
delimiters.

(alternatively, you can close excel and reopen it.)
 
Back
Top