Forum Discussion
How to selectively split cells
Hello, noob here. I have a giant list of data that I copied from a pdf online and I need to selectively separate it into separate cells so that I can work with it. Right now it is all in one column, ...
Looking at the attachment, it appears your data may have two numbers on the back end after a variable length string that can have both numbers and letters (so my suggestion would still leave a piece at the end that would need to be split).
If that's the case, then let me know. I believe we can split the last piece by finding the character positions of the last and next to last spaces and using text functions to split the remaining three columns.
Or, are the two numbers in a row by themselves (alternating rows of long text string then a string of two numbers)?
If you can share it, maybe it would help to upload the file.