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!

*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.

Jobs

Tabular Data to Excel

Tabular Data to Excel

(OP)
I always copy and paste tabular data from Ansys Mechanical into Excel
Copying an entire table from Ansys and select a single cell in Excel (not "in" the cell), then hit paste and -bam- each cell is populated correctly

Now, for some reason, when I copy and paste all the values are going into one single cell as a text string.
I have tried restarting everything but still the issue persists.
I must have messed up an Excel or Ansys setting.
I want to copy and paste again.
Help

RE: Tabular Data to Excel

That is odd. Could it work by right clicking and pasting as values? I think the problem is not in
Ansys.

RE: Tabular Data to Excel

In Excel, try Data Tab>text-to-column, delimited, check all that applies.

Best regards,
Jason

RE: Tabular Data to Excel

(OP)
thank guys.
I fixed it.
It was Excel, not Ansys
Went to control panel>uninstall programs -- then right click on Microsoft office -- then clicked repair program.
That reset all office programs to default settings. Then I restarted and was ok

RE: Tabular Data to Excel

I'm sure it is an Excel problem, but there must be an easier way than going through the repair program procedure. I couldn't find anything though, either in the Options menus, or from a quick search on-line. I vaguely remember having the same problem some time ago (from a different FEA program), but it just went away.

Anyone else have a quick solution, not requiring re-setting everything?

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Tabular Data to Excel

I've noticed that when cutting and pasting text format into Excel it often seems to have some sort of memory. Personally I'd rather it behaved as in the OP, and leave the user to explicitly request text to columns.

Cheers

Greg Locock


New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?

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


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close