So I had succeeded in finally getting the pdf file converted into a semi-workable format. Some data is formatted fine, but other pages are formatted with a bunch of data input into a single cell (40-50 items). I can't get pro without my company first approving it, so I am trying to code a work-around to automate this otherwise mundane tax. New to scripting in Excel, however I did take coding classes in college. I have attached two screenshots, one with the problematic formatting, and the latter with desired formatting. The idea I have now is to have excel find instances of FP and then inserting a line-break before it. But that doesn't result in the data being in its own cell. Anyway to do this? I am reading up to try to figure it out, but if anyone can point me in the right direction, that would be great.

http://imgur.com/a/ln2uA <---- Problem Data

http://imgur.com/a/PKfMM <----- Correct Data