Anonymous ID: 49eec4 Jan. 21, 2019, 4:28 p.m. No.4853161   🗄️.is 🔗kun

>>4853018

this might be a big ask spreadsheet fag but it would be amazing if i could split this up..you work on the q post spreadsheet while i work on the potus tweets one? i just need them in order of minute:seconds for a theory i'm working on

 

totally understand if it's not something you'd want to undertake though

Anonymous ID: 49eec4 Jan. 21, 2019, 4:48 p.m. No.4853407   🗄️.is 🔗kun   >>3464

>>4853346 so that works by counting the number of characters left? if so, that wouldn't work for what i'm trying to do as i have a lot of data to remove on either side of the timestamp

i need the first 15 characters removed

assuming =left(A1, 15) wouldn't work right?

Anonymous ID: 49eec4 Jan. 21, 2019, 4:57 p.m. No.4853519   🗄️.is 🔗kun

>>4853464

 

Jan 29, 2017 06:39:53 PMI will be interviewed by @TheBrodyFile on @CBNNews tonight at 11pm. Enjoy! [Twitter for iPhone] link

 

needs to be:

 

39:53 PMI will be interviewed by @TheBrodyFile on @CBNNews tonight at 11pm. Enjoy! [Twitter for iPhone] link

 

so just remove the first 15 characters (some have double digit in the day so i would just remove the extra character for those afterwards but for now it would help to get rid of the date and hour

 

(i just copy/pasted raw data from trump archive into excel so each tweet is in one cell but ideally the timestamp and tweet would be in separate adjacent cells)