Author Topic: microsoft word-excel- office  (Read 118010 times)

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 17361
  • Total likes: 14274
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: microsoft word-excel- office
« Reply #320 on: August 10, 2015, 03:31:19 PM »
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
Feelings don't care about your facts

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #321 on: August 10, 2015, 04:05:53 PM »
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.
Workflowy. You won't know what you're missing until you try it.

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 17361
  • Total likes: 14274
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: microsoft word-excel- office
« Reply #322 on: August 10, 2015, 04:42:42 PM »
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
Feelings don't care about your facts

Offline smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4525
  • Total likes: 276
  • DansDeals.com Hat Tips 8
    • View Profile
  • Location: NJ
Re: microsoft word-excel- office
« Reply #323 on: August 10, 2015, 06:31:52 PM »
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"

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #324 on: August 11, 2015, 10:42:24 AM »
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 :(
Workflowy. You won't know what you're missing until you try it.

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 17361
  • Total likes: 14274
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: microsoft word-excel- office
« Reply #325 on: August 11, 2015, 11:03:03 AM »
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?
Feelings don't care about your facts

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #326 on: August 11, 2015, 11:09:56 AM »
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).
Workflowy. You won't know what you're missing until you try it.

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 17361
  • Total likes: 14274
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: microsoft word-excel- office
« Reply #327 on: August 11, 2015, 11:40:31 AM »
So just copy each column separately into an excel column
Feelings don't care about your facts

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #328 on: August 11, 2015, 11:47:09 AM »
So just copy each column separately into an excel column
A little clumsy, but it works. Thanks!
Workflowy. You won't know what you're missing until you try it.

Offline samzyr

  • Dansdeals Gold Elite
  • ***
  • Join Date: May 2011
  • Posts: 176
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: USA
Re: microsoft word-excel- office
« Reply #329 on: August 16, 2015, 06:20:40 PM »
where is the cheapest place to Microsoft office?

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2181
  • Total likes: 26
  • DansDeals.com Hat Tips 2
    • View Profile
Re: microsoft word-excel- office
« Reply #330 on: August 17, 2015, 05:28:10 AM »
where is the cheapest place to Microsoft office?
Legally?  Which version?
For tech help feel free to Telegram me @DanTechSupp

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Workflowy. You won't know what you're missing until you try it.

Offline Aaaron

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2012
  • Posts: 1360
  • Total likes: 37
  • DansDeals.com Hat Tips 3
    • View Profile
  • Location: Baltimore
Re: microsoft word-excel- office
« Reply #332 on: October 19, 2015, 05:55:01 PM »
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.



Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3809
  • Total likes: 822
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: microsoft word-excel- office
« Reply #333 on: October 19, 2015, 06:04:55 PM »
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.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #334 on: October 19, 2015, 08:14:30 PM »
I think you can also just drag the file (from its folder) into an Excel window.
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #335 on: October 19, 2015, 08:28:56 PM »
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.

Offline Aaaron

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2012
  • Posts: 1360
  • Total likes: 37
  • DansDeals.com Hat Tips 3
    • View Profile
  • Location: Baltimore
Re: microsoft word-excel- office
« Reply #336 on: October 19, 2015, 08:37:57 PM »
Almost got it done. Thanks, y'all!

Offline Centro

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2012
  • Posts: 2935
  • Total likes: 8
  • DansDeals.com Hat Tips 33
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« Reply #337 on: October 20, 2015, 08:00:24 PM »
N00b at Word...


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

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12855
  • Total likes: 3302
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #338 on: October 20, 2015, 08:37:31 PM »
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
Workflowy. You won't know what you're missing until you try it.

Offline Centro

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2012
  • Posts: 2935
  • Total likes: 8
  • DansDeals.com Hat Tips 33
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« Reply #339 on: October 20, 2015, 08:38:49 PM »