splitting a cell that has two values separated by a space

Hi,
I'm here cause I'm stumped. I have a massive amount of pdf's that need to have data extracted so I can run some analysis. After searching around the net and trying out several ocr and pdf file converters, I found a program that spits out the data I'm trying to work with in a relatively acceptable manner however there is a LOT of reformatting and reentering of data involved. I have used LEN/RIGHT/LEFT functions to extract data out of a string, but I don't think these functions will do what I need done especially when the character strings are not consistent in length and there is no 'trigger' to look for except that the values are separated by a space . I have a feeling to get what I want, VBA might be the only way. While relatively experienced with Excel I am an ultra newbie to VBA and I'm willing to learn. The extent of my VBA is finding a template and adjusting to my needs.

I can greatly reduce the amount of time of the data reentry if I can figure out how to solve this conundrum: I have columns represent a particular type of statistic, and then the rows are the record that the stat applies to. However each corresponding cell intersections has two points of data which correspond to year 1 and year 2. I want to get each of these pieces of data into their 'own' cell and in the correct row. The data I need to split is displayed as a 'wrap text' which can easily be undone, please see my attachment with the ideal before and after array. Thanks in advance for the help!

formula start at B11

=TRIM(MID(SUBSTITUTE(OFFSET(B$2,TRUNC((ROW(1:1)-1)/2)+1,,,),CHAR(10),REPT(" ",100)),IF(ISODD(ROW(1:1)),1,100),100))

drag right and down

Great solutions, tested them and they all work! Much appreciated ! I now have some new formulas to master and I just found an ASCII table so I can use CHAR more elaborately.