×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Stop Text to Columns
2

Stop Text to Columns

Stop Text to Columns

(OP)
I have been block copying text into cells successfully then something happened to my file.  Now instead of dropping the whole sentence into a cell it does an automatic 'text to column' and spreads the sentence across cells, one word to a cell.

This has to be a global option of some sort.  How do I change it back so all the text goes into one cell?

Roger

RE: Stop Text to Columns

rnordquest,

The text to columns works in an odd way.  It would appear that the last time you used text to columns in that session of excel use, sets the default settings for the rest of that session.

What this means is that if you have used the text to columns to parse something using spaces, then spaces is the default delimiter.  When you then cut and paste the 'microsoft helpful' function recognises this as space delimited and consequently screws up your work.  The way to get out of it is to do a text to columns using characters you never would paste in, thereby setting up new settings.

Hope this helps,

Craig

RE: Stop Text to Columns

This is my work around, select the paste-to cell, hit any character key, then backspace, then ctrl+v.  Work nice if you want to loose all the formatting on the copied data as well.

Ken

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources