>>4853519 lb
First, you’ll want to separate the time stamps from the tweet text. To do this, highlight your column then click “Data”, “Data tools”, then “text to columns”, then “delimited”. You’ll be able to set your parameters there. You can set it to a specific character or space count. This will separate your state and time stamp from tweet text. then de Assuming the text of the tweet is in a separate cell and the date/time resides in its own cell =right(A1, 5) should work.
I feel so comfy with other excelfags. Makes me so happy.
Saving the world one spreadsheet at a time. Kek.
Very good thought. Very doable. Once you separate the time stamps from the text, you could do an index match formula that populates the matching texts. Is there a way to have an anonymously shared spreadsheet between anons so we could collaborate together? I typically have a lot of free time during work hours.
If I’m not mistaken, there were some clockfags that had data broken down into excel documents. Maybe check the clockfag breads