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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel is automatically doing "text to columns" upon paste text. (https://www.excelbanter.com/excel-discussion-misc-queries/30874-excel-automatically-doing-%22text-columns%22-upon-paste-text.html)

robert10000

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

How do I stop Excel from automatically doing "text to columns" when I paste
text/numbers from a document?

Barb R.

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

"robert10000" wrote:

How do I stop Excel from automatically doing "text to columns" when I paste
text/numbers from a document?

All times are GMT +1. The time now is 02:56 PM.