Excel is automatically doing "text to columns" upon paste text.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I stop Excel from automatically doing "text to columns" when I paste
text/numbers from a document?
 
You probably have a delimiter set for TEXT TO COLUMNS within the spreadsheet
you are editing. Before pasting the text/numbers from the document, do a
TEXT TO COLUMNS parse on no data and deselect all of the delimiters that are
set. Then paste in the data you want to paste.

Come back if you have more questions.

Barb Reinhardt
 
You must log in or register to reply here.

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

Why this paste result? 4
Changing Text To Numbers ? 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Paste Formatting 5
Text to Columns Error 1
Text to Columns 1
Excels brilliant memory 1
Text to Columns Question 1

Back
Top