16.03.2020, 15:41
Hi There!
I am generating lots of data and would like to copy paste it into an Excel sheet. However, some part of the copied data is trash and therefore I dont want it to be added to the cells when I import the text because I would have to manually remove the "trash" in each cell.
How can I make sure that only the relevant text is being imported into the cells?
The format of the text to be copy-pasted looks like this:
1,"1GTj6KVRTUF9iSccXSFUuyZFGovWpcFKHs","5JjAiH3C9AYLBWKxnzBBNipFq64m97Gumddyu3Pe2H4yQeatBQ5"
2,"17MVWMvSmNxEyhpJMkJg7FG97WKA7dx23U","5JNVqbDs8vc7rGCnLbnpuxVt1bGQrEUopD9JHbjLSSDiuL7N3tp"
3,"1Q1d5QysdEjvs6PtSioHR87rKXJ1ZrHRNX","5JikGUNtVMbd4msy6C7biDxvzHmszY8CVJr5HwowCbu1ScEoHGd"
I would like to import the strings of letters in two horizontal cells. So for example 1st cell (A1) should contain 1GTj6KVRTUF9iSccXSFUuyZFGovWpcFKHs and the second cell (B1) should contain 5JjAiH3C9AYLBWKxnzBBNipFq64m97Gumddyu3Pe2H4yQeatBQ5
Is there a way to do this?
Thanks a lot for your help!
Best,
m4nki
I am generating lots of data and would like to copy paste it into an Excel sheet. However, some part of the copied data is trash and therefore I dont want it to be added to the cells when I import the text because I would have to manually remove the "trash" in each cell.
How can I make sure that only the relevant text is being imported into the cells?
The format of the text to be copy-pasted looks like this:
1,"1GTj6KVRTUF9iSccXSFUuyZFGovWpcFKHs","5JjAiH3C9AYLBWKxnzBBNipFq64m97Gumddyu3Pe2H4yQeatBQ5"
2,"17MVWMvSmNxEyhpJMkJg7FG97WKA7dx23U","5JNVqbDs8vc7rGCnLbnpuxVt1bGQrEUopD9JHbjLSSDiuL7N3tp"
3,"1Q1d5QysdEjvs6PtSioHR87rKXJ1ZrHRNX","5JikGUNtVMbd4msy6C7biDxvzHmszY8CVJr5HwowCbu1ScEoHGd"
I would like to import the strings of letters in two horizontal cells. So for example 1st cell (A1) should contain 1GTj6KVRTUF9iSccXSFUuyZFGovWpcFKHs and the second cell (B1) should contain 5JjAiH3C9AYLBWKxnzBBNipFq64m97Gumddyu3Pe2H4yQeatBQ5
Is there a way to do this?
Thanks a lot for your help!
Best,
m4nki