Copying & pasting data - Google Sheets

[@JacobSolorzano]

how do i paste data that is not in excel/sheets format, without it being pasted into 1 single box or even 1 single row? if not possible, is there a way i can highlight certain data and shift it over(paste) to the next column (to the right) without having to manually copy and paste it? EX. I have data from a PDF file and everytime I paste it the best i can do is have them separated in the vertical column, but not the horitzontal.

[@AbouBFunna]

Wow. Great job. Thanks for your help.

[@rachaelmontague3214]

Excellent , only person to mention that feature, thank you

[@emilylukuta6148]

Hi, I’ve got a R assignment that I need help with and I’m clueless with R , deadline is 1 of august is it possible if u can help me with it and I’m willing to pay $300 for the assignments

[@martagolab9159]

its so nice to hear clean english accent

[@mayy9685]

Not really

[@taneshawalker]

Thank you, Thank you!!

[@superfitjt1805]

thank you sir this really helped me out :)

[@emilylukuta6148]

Hi, I’ve got a R assignment that I need help with and I’m clueless with R , deadline is 1 of august is it possible if u can help me with it and I’m willing to pay $300 for the assignments

[@BethanyRenner]

Sooooooo helpful! Thank you sir!

[@emilylukuta6148]

Hi, I’ve got a R assignment that I need help with and I’m clueless with R , deadline is 1 of august is it possible if u can help me with it and I’m willing to pay $300 for the assignments

[@mikrandr]

2:28 Thank you so much!

[@reemhesham7139]

Thank you so much!

[@ritugupta1971]

Sir how to paste the same text in multiple cells

[@thecookiehunterz8169]

Copying and pasting somehow fucks it up for me

[@emilylukuta6148]

Hi, I’ve got a R assignment that I need help with and I’m clueless with R , deadline is 1 of august is it possible if u can help me with it and I’m willing to pay $300 for the assignments

[@melindaaryani4466]

hi sir, would you please inform me how to paste comment from microsoft excel into gsheet? thank you

[@MuhammadHusni24]

yes, i need this too!

[@waynefilkins8394]

my whole table pastes in 1 column. I'm coyping it from a weird site (jungle scout) so it's maybe a javascript or something table idk...i just can't get it to paste right :(

[@emilylukuta6148]

Hi, I’ve got a R assignment that I need help with and I’m clueless with R , deadline is 1 of august is it possible if u can help me with it and I’m willing to pay $300 for the assignments

[@haelenbetancourt4906]

did you ever figure out what was wrong? i’m having this problem and idk what to do. it never used to do this, and now i can’t figure out what i’m doing wrong lol

[@waynefilkins8394]

@@haelenbetancourt4906 Yeah but I can't remember what I did lol

[@haelenbetancourt4906]

@@waynefilkins8394 lol

[@mosabgamal7024]

Thx

[@CoachNick]

thank u sir! very helpful--do u also know how to import data that's solely text separated by commas?

[@datalabcc]

Normally you would import that as a "CSV," which stands for "comma-separated values." Is your data in a CSV style spreadsheet or is it in a text file? Bart

[@CoachNick]

@@datalabcc it was in a text file sir. I later figured out i could just ctrl+a the entire HTML website and then cut and paste, but i wasn't able to figure out how to convert text file w/ data separated by commas into a google spread sheet.

[@datalabcc]

@@CoachNick Got it. Usually, if you copy just the table part of the webpage (which you can do by clicking and dragging over it), you can paste it into a Google Sheet and it will format properly. Usually, not always. There are also several Chrome extensions available from the Chrome Web Store that will copy web tables for you. But here's how you can import a text file with comma-separated values into a new Google Sheet. (Note that this works best if you have ONLY the values you want to import in the text file, and no headers, images, etc.) 1. Open a blank sheet in Google Sheets 2. Go to File > Import 3. Select the "Upload" tab and choose the file you want to import 4. When the "Import file" dialogue pops up, you can choose the location (you'll probably want the fourth option, "Replace current sheet" and you can can select "Comma" under "Separator Type." You can leave the last option "Convert text to numbers, dates, and formulas" as "Yes." Then click "Import data." 5. Hopefully that will show you what you need.

[@CoachNick]

@@datalabcc awesome, thanks for the update, i will have to try that next time

[@unplugged301]

my problem is how can I copy and paste for 30,000 columns?

[@shubh_00]

😂

[@TheAireaidLord]

why are these programs so fucking difficult and non user friendly fucking hell holy fuck!!!!! all i want to do is paste my data across the fucking page