RE: Copying(?) and Pasting Work Tables into Excel?

Subject: RE: Copying(?) and Pasting Work Tables into Excel?
From: Slager Timothy J <Timothy -dot- Slager -at- dematic -dot- com>
To: Emoto <emoto1 -at- gmail -dot- com>, TECHWR-L <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Wed, 6 Sep 2017 12:19:12 +0000

Bob,

If I understand correctly, you can try this.
- In Word, convert table to text (Table Tools - Layout).
- Remove lingering formatting, if any.
- Convert text to table (Insert > Tables)
You may want to skip the last step and import the table into Excel in text format.

Hope this helps. tims

-----Original Message-----
From: techwr-l-bounces+timothy -dot- slager=dematic -dot- com -at- lists -dot- techwr-l -dot- com [mailto:techwr-l-bounces+timothy -dot- slager=dematic -dot- com -at- lists -dot- techwr-l -dot- com] On Behalf Of Emoto
Sent: Tuesday, September 05, 2017 3:35 PM
To: TECHWR-L
Subject: Copying(?) and Pasting Work Tables into Excel?

I have a bunch of tables made in Word with shading and so forth that I need to pull into Excel. Just text, no formulas. Some cells will be grey, but I need to have individual ones be white, so that someone can hand-write something there.

These are two small examples, but they show that not everything is the same width or height. So far, I have not been able to discover a "good" way to do this, in spite of trying.

I hate to have to copy and paste cell by cell, but it may come to that.
Tips? Tricks?

I cannot paste as images because people after me may need to edit the content.

Examples:


Blah Item(s)
The blahdy blah blah blah include:
Parent YADDA Name Yadda Item booboor
Xyz- pkuu-nnee 376165485872
FTY-HOIE_-EERTT 65927494762782


gizmo(s)
The gizmo(s) associated with blah de blah de blah:
SDAGASGF FOFOF YDAA GHU
CDR-YOYOYO




Thanks!


Bob
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Visit TechWhirl for the latest on content technology, content strategy and content development | https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftechwhirl.com&data=01%7C01%7CTimothy.Slager%40dematic.com%7C4eaf915396764c6f7b8108d4f462fe5b%7Cb87688c18bb44f8698754da105de8eda%7C1&sdata=GoTs26mhVETA9ivypn4QDjKgmGGvgIIGFr8nsnllXXM%3D&reserved=0

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You are currently subscribed to TECHWR-L as Timothy -dot- Slager -at- dematic -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-leave -at- lists -dot- techwr-l -dot- com


Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.techwhirl.com%2Femail-discussion-groups%2F&data=01%7C01%7CTimothy.Slager%40dematic.com%7C4eaf915396764c6f7b8108d4f462fe5b%7Cb87688c18bb44f8698754da105de8eda%7C1&sdata=qawhuoecu%2BXH9y4w7AKUQVONFl9Lwb45YS%2BGJtJmirs%3D&reserved=0 for more resources and info.

Looking for articles on Technical Communications? Head over to our online magazine at https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftechwhirl.com&data=01%7C01%7CTimothy.Slager%40dematic.com%7C4eaf915396764c6f7b8108d4f462fe5b%7Cb87688c18bb44f8698754da105de8eda%7C1&sdata=GoTs26mhVETA9ivypn4QDjKgmGGvgIIGFr8nsnllXXM%3D&reserved=0

Looking for the archived Techwr-l email discussions? Search our public email archives @ https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftechwr-l.com%2Farchives&data=01%7C01%7CTimothy.Slager%40dematic.com%7C4eaf915396764c6f7b8108d4f462fe5b%7Cb87688c18bb44f8698754da105de8eda%7C1&sdata=gRiX1RzpHYVPItX1JiAZzQLiRWNW0lFIiFpcn%2BzGbjI%3D&reserved=0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Visit TechWhirl for the latest on content technology, content strategy and content development | http://techwhirl.com

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-leave -at- lists -dot- techwr-l -dot- com


Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwhirl.com/email-discussion-groups/ for more resources and info.

Looking for articles on Technical Communications? Head over to our online magazine at http://techwhirl.com

Looking for the archived Techwr-l email discussions? Search our public email archives @ http://techwr-l.com/archives


References:
Copying(?) and Pasting Work Tables into Excel?: From: Emoto

Previous by Author: RE: Context sensitive pop-ups
Next by Author: Context sensitive pop-ups (yehoshua paul)
Previous by Thread: Copying(?) and Pasting Work Tables into Excel?
Next by Thread: Re: Context sensitive pop-ups


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads