Word Columns to Spreadsheet

[Doug Kanter]

I've got a Word doc in which the user created two columns using the tab key.
Not a table, in other words. I need to copy the two columns to Excel and
have them land in separate columns. Is there a way to change the Word doc so
the stuff I copy is more likely to land that way in Excel? I know I can
parse the text once it gets to Excel, but then I have to strip out blank
spaces at the beginning of the stuff in the 2nd columns blah blah
blah....too many keystrokes.

Any tips? This is all text, by the way. No numbers.

 

[Rob graham]

I've got a Word doc in which the user created two columns using the tab
key. Not a table, in other words. I need to copy the two columns to Excel
and have them land in separate columns. Is there a way to change the Word
doc so the stuff I copy is more likely to land that way in Excel? I know I
can parse the text once it gets to Excel, but then I have to strip out
blank spaces at the beginning of the stuff in the 2nd columns blah blah
blah....too many keystrokes.

Any tips? This is all text, by the way. No numbers.

Table/Convert/Text to Table. Once it's a table then it will copy and paste
into Excel.

Rob Graham

 

[Doug Kanter]

Table/Convert/Text to Table. Once it's a table then it will copy and paste
into Excel.

Rob Graham

Thank you, Rob.

 

[Doug Kanter]

Table/Convert/Text to Table. Once it's a table then it will copy and paste
into Excel.

Rob Graham

The Draw Table command turned out to be a better option. The Convert method
got confused by the lack of visible delimiters, and using tabs didn't help
because there were different numbers of tabs depending on the length of each
line of text. But, your pointer was still helpful, so thanks again!

 

[anon k]

Table/Convert/Text to Table. Once it's a table then it will copy and paste
into Excel.

Rob Graham

One other useful thing to know about in Excel is the TRIM function. It
strips away leading and trailing spaces.

In Word, you can achieve this in many cases by replacing all double
spaces with nothing, and replacing all paragraph-plus-space pairs with
just a paragraph.

 

[Rob graham]

The Draw Table command turned out to be a better option. The Convert
method
got confused by the lack of visible delimiters, and using tabs didn't help
because there were different numbers of tabs depending on the length of
each line of text. But, your pointer was still helpful, so thanks again!

Good to know.