microsoft word-excel- office

[aygart]

I have a document that contains a "pretend" table, made by tab stops. Is there any way to convert it to a regular table in Word so that I can copy it to excel?

copy it as is into excel and use text to columns

[etech0]

copy it as is into excel and use text to columns

when i copy it into xl it puts it all into 1 column - a new line for each 'cell' of the original table.

[aygart]

when i copy it into xl it puts it all into 1 column - a new line for each 'cell' of the original table.

meaning it makes a line in place of the tabs? Try pasting values

[smurf]

I have a document that contains a "pretend" table, made by tab stops. Is there any way to convert it to a regular table in Word so that I can copy it to excel?

should be openable in excel as "tab delimited"

[etech0]

meaning it makes a line in place of the tabs? Try pasting values

It's not an option

EDIT:
I just realized that it's not set up with tab stops, but with columns in the word doc. Still can't figure out how to copy to excel

[aygart]

I do this all the time by selecting the entire chart using the little plus sign on the top right and then using ctrl c and ctrl v. This isn't working for you?

[etech0]

I do this all the time by selecting the entire chart using the little plus sign on the top right and then using ctrl c and ctrl v. This isn't working for you?

So do I. But this is not a chart. It's clumsily made using Columns.

Basically the document has four columns (not a table), something like this:


So the data is not even typed in in the right order (ie: it goes down, and then back to the top for the second column, instead of going across one row at a time).

[aygart]

So just copy each column separately into an excel column

[etech0]

So just copy each column separately into an excel column

A little clumsy, but it works. Thanks!

[samzyr]

where is the cheapest place to Microsoft office?

[DanH]

where is the cheapest place to Microsoft office?

Legally?  Which version?

[etech0]

http://www.makeuseof.com/tag/find-every-microsoft-office-keyboard-shortcut-ever-need/

[Aaaron]

Is there any [easy] way to merge a .txt or .pdf into excel?  This is what it currently looks like in notepad; those first three columns should ideally be merged into one, but in the reverse order.

[skyguy918]

Is there any [easy] way to merge a .txt or .pdf into excel?  This is what it currently looks like in notepad; those first three columns should ideally be merged into one, but in the reverse order.

Copy/paste that into excel and then use text-to-columns to separate the data, at which point you can play around with the data and merge columns in whatever order you'd like.

Also, there's an Excel questions thread, probably belongs there.

[etech0]

I think you can also just drag the file (from its folder) into an Excel window.

[churnbabychurn]

Is there any [easy] way to merge a .txt or .pdf into excel?  This is what it currently looks like in notepad; those first three columns should ideally be merged into one, but in the reverse order.

Read this.
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba

PDF is a whole different issue. - with adobe you could save as/convert to excel but its messy.

[Aaaron]

Almost got it done. Thanks, y'all!

[Centro]

N00b at Word...


Im trying to type this up in word, how would I do it?

[etech0]

N00b at Word...


Im trying to type this up in word, how would I do it?

on the Insert ribbon, click Drop Caps. Then click Dropped.

for screenshots: http://www.addintools.com/documents/word/word-how-to/how-to-drop-cap.html

[Centro]

on the Insert ribbon, click Drop Caps. Then click Dropped.

for screenshots: http://www.addintools.com/documents/word/word-how-to/how-to-drop-cap.html

Thx!