Forum
»
Officecels - excel help (reps)
- Results 1 to 16 of 16
-
Page 1 of 1
Thread: Officecels - excel help (reps)
10-20-2020, 10:28 AM
-
#1
- Glutebrahhh
- Glutes of Peace
-
- Glutebrahhh
- Glutes of Peace
- Join Date: Sep 2020
- Posts: 4,079
- Rep Power: 16807
-
-
Officecels - excel help (reps)
Misc, I'm trying to work with a large amount of information from an HTML file, but if I select all, and attempt to paste into excel, everything crashes. I think it works out to ~25000 lines (I need to do this several times).
Can anyone recommend a solution? I might be able to get the info in .txt format, but idk if that would copy into excel as well..
Buy new i9 computer?
Steal quantum computer?
Ldar?
for time
Can anyone recommend a solution? I might be able to get the info in .txt format, but idk if that would copy into excel as well..
Buy new i9 computer?
Steal quantum computer?
Ldar?
for time
10-20-2020, 10:41 AM
-
#2
10-20-2020, 10:43 AM
-
#3
10-20-2020, 10:45 AM
-
#4
- Glutebrahhh
- Glutes of Peace
-
- Glutebrahhh
- Glutes of Peace
- Join Date: Sep 2020
- Posts: 4,079
- Rep Power: 16807
-
-
Originally Posted By armyr0b⏩
Well it's a downloaded html link, so it looks like file:///C:/Users/Owner/Desktop/message_1.htmlalso, you should post the .html link so i can take a look see about another solution
I think the only files I can get are html and .txt
10-20-2020, 10:56 AM
-
#5
- armyr0b
- Registered User
-
- armyr0b
- Registered User
- Join Date: Jan 2008
- Location: Connecticut, United States
- Age: 46
- Posts: 6,321
- Rep Power: 21214
-
-
Originally Posted By Glutebrahhh⏩
yeah thats on your drive. try to copy and save as a .csv, it can handle much better than .xslWell it's a downloaded html link, so it looks like file:///C:/Users/Owner/Desktop/message_1.html
I think the only files I can get are html and .txt
I think the only files I can get are html and .txt
PS4
New England Patriots
10-20-2020, 10:58 AM
-
#6
- Destor
- Registered User
-
- Destor
- Registered User
- Join Date: Apr 2012
- Location: Alberta, Canada
- Age: 41
- Posts: 43,481
- Rep Power: 254906
-
-
Hey good pic brah
I would try copying and pasting in chunks, but first right click to paste and select Match Destination Formatting to try pruning out any weird formats it may be trying to insert
I would try copying and pasting in chunks, but first right click to paste and select Match Destination Formatting to try pruning out any weird formats it may be trying to insert
10-20-2020, 10:59 AM
-
#7
10-20-2020, 11:09 AM
-
#8
- Glutebrahhh
- Glutes of Peace
-
- Glutebrahhh
- Glutes of Peace
- Join Date: Sep 2020
- Posts: 4,079
- Rep Power: 16807
-
-
Originally Posted By sf813⏩
I've certainly tried this but then I'm sitting there scrolling through thousands of lines.... It'd take me an hour to paste the first document.. and I got 5 of em.Try copy and pasting in pieces, not all at once
10-20-2020, 11:10 AM
-
#9
- Hunttarded
- ♔
- Join Date: Feb 2013
- Posts: 5,174
- Rep Power: 49867
-
-
Try retrieving data using Power Query.
10-20-2020, 11:45 AM
-
#10
- Glutebrahhh
- Glutes of Peace
-
- Glutebrahhh
- Glutes of Peace
- Join Date: Sep 2020
- Posts: 4,079
- Rep Power: 16807
-
-
Originally Posted By Destor⏩
My brah, das it mane - seconds. Literally 2, brb 30k lines posted like nothin.Hey good pic brah
I would try copying and pasting in chunks, but first right click to paste and select Match Destination Formatting to try pruning out any weird formats it may be trying to insert
I would try copying and pasting in chunks, but first right click to paste and select Match Destination Formatting to try pruning out any weird formats it may be trying to insert
10-20-2020, 12:03 PM
-
#11
- Destor
- Registered User
-
- Destor
- Registered User
- Join Date: Apr 2012
- Location: Alberta, Canada
- Age: 41
- Posts: 43,481
- Rep Power: 254906
-
-
[QUOTE=Glutebrahhh post_id=1619900691]My brah, das it mane - seconds. Literally 2, brb 30k lines posted like nothin.
[img]https://i.imgur.com/L4bIoGZ.png[/QUOTE]Had a feeling that would do it, the formatting would have been throwing it off
[img]https://i.imgur.com/L4bIoGZ.png[/QUOTE]Had a feeling that would do it, the formatting would have been throwing it off
10-20-2020, 12:14 PM
-
#12
10-20-2020, 12:25 PM
-
#13
10-20-2020, 12:33 PM
-
#14
- GodlessWonder
- Darkness is coming
-
- GodlessWonder
- Darkness is coming
- Join Date: Jul 2020
- Posts: 411
- Rep Power: 1723
-
-
Originally Posted By Hunttarded⏩
Listen to this guy. Power Query will save you lots of time and make your bosses think you're a genius.Try retrieving data using Power Query.
It's also WELL worth it to learn it. It's called Get & Transform in some versions of Excel for some dumb reason.
10-20-2020, 12:37 PM
-
#15
- Glutebrahhh
- Glutes of Peace
-
- Glutebrahhh
- Glutes of Peace
- Join Date: Sep 2020
- Posts: 4,079
- Rep Power: 16807
-
-
Originally Posted By memcop⏩
Save As
CSV (Delimited)
See if it opens up
If you guys went from win 7 to 10 then you are fkd lol
nm you got it
CSV (Delimited)
See if it opens up
If you guys went from win 7 to 10 then you are fkd lol
nm you got it
a mod in my threadOriginally Posted By GodlessWonder⏩
I will still get familiar with this, a quick google and it seemed like a very useful tool.Listen to this guy. Power Query will save you lots of time and make your bosses think you're a genius.
It's also WELL worth it to learn it. It's called Get & Transform in some versions of Excel for some dumb reason.
It's also WELL worth it to learn it. It's called Get & Transform in some versions of Excel for some dumb reason.
Bookmarks
-
- Digg
-
- del.icio.us
-
- StumbleUpon
-
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts