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

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
 
D

Dave Peterson

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Document Merge Formatting Issue 0
How can the font and size of (all) citation numbers be altered? 1
How to center adjust text above and image in a two column document. 1
Referring to columns in the text of a cell 2
Text to Columns problem 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I clear a form? 0
How to copy non-contiguous columns to a text file 62

Top