<div>
Can you provide an example file? &nbsp;Is there a reason why you do not open the file directly from excel and use the conversion tool to map the columns if any needed?
</div>


Can you provide an example file?  Is there a reason why you do not open the file directly from excel and use the conversion tool to map the columns if any needed?

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
When I paste information from a text file into an Excel spreadsheet, the data gets automatically separated into columns. <br />
<br />
Is there a way to prevent this? I have already tried to change the format of the worksheet.<br />
<br />
Thank you. 
</div>
</div>


Hi, 

When I paste information from a text file into an Excel spreadsheet, the data gets automatically separated into columns. 

Is there a way to prevent this? I have already tried to change the format of the worksheet.

Thank you. 

Excel - Do not want automatic Text to Columns

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.