• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 720
  • Last Modified:

Excel - Do not want automatic Text to Columns

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.
0
tahirih
Asked:
tahirih
  • 2
1 Solution
 
ajcheung78Commented:
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?
0
 
redmondbCommented:
Hi, tahirih.

Without seeing you text file, I suspect that it is using tabs. When you paste the data into Excel, it uses the Text to Column delimiter setting - which defaults to the tab. You could bypass this by changing the setting to have no delimiter and so Excel would treat the tab as just another character.

There are a couple of problems with this approach...
(1) When Excel loads, it resets the delimiter default back to tab.
(2) Excel doesn't handle the tab character in a cell very well. There's no visible sign that it's there - until you edit it, when peculiar things happen.

Echoing ajcheung78's request, could you post an example of both the source test file (just a few entries and changed as necessary for confidentiality) plus the desired Excel results?

Thanks,
Brian.

0
 
tahirihAuthor Commented:
Thank you.
0
 
redmondbCommented:
Thanks, tahirih.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now