i wish someone more technologically inclined than me could figure out a way to sort potus tweets and q posts by timestamp (minutes, seconds only)
that's exactly what i was about to do kek
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
or would you happen to know a formula that could remove by bulk x amount of first characters in a cell?
>>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?
>>4852860 if bakers don't do a good job, you're welcome to join the kitchen and show us what you got
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)