Re: spliting single cell data w/ spaces btwn the data into new cells / pdf to Excel c
Tried for a while to get around the importing from pdf, not going very well as of yet.
While dealing with your example though, had a little progress.
Ok... few steps here, but best I can do as of right now...
Lets look at cell F3 in your example.
Right now the soft line breaks are causing excel to not seperate the numbers.
If you highlight that cell, and select replace, then under the replace what section hold alt down, then press 010 on the keypad.
Under the replace with section, enter a single space.
That will add a space between every item in that cell, by replacing every soft line break with one.
Next, select the cell and go to the data tab.
Select text to columns.
Only select spaces when given the option,
and leave general in the next section.
Once that is done, you'll have all your information in one row.
From there, select the entire row, and Copy it.
Right click, and select paste special. Then select transpose.
That will paste the information in a vertical format for you, which will allow you to select the columns you need and paste the information where you need it.
It will work with any cell that has multiple information in it, like F3 does in your example.
Still quite a few steps to get where you want, sorry for that. Will try to work on this as I can, but at least as it stands now you can start sorting the data. Also been working on basic macros to to text to columns and then transpose, but not sure if that would be a route you'd like to go.