Text-to Column

I have been trying to used text to colums, however my rows are of varying information and the "split" needs to be a varying places in the row. I need to be able to do this with multiple rows, as my spreadsheet that I am working on has 1800 lines. The only common denominator regarding where to split at, is when my text switches to numbers at a point in my text. I have been unsuccessful in figuring out how to do this and would appreciate it if anyone out there can help me accomplish this. I have been working on a conversion that was a "dirty" conversion and many, many lines were converted with multiple colums placed in the same column in excel. I have been an Excel user for 20 years, albeit just for basics, and I am new to pdf conversions. Both programs are amazing, escpecially Excel, but I am frustrated that I cannot find a way to use the text to column feature to a greater capacity in Excel. I hope someone out there can help me.

I have pasted 4 lines of the converted spreadsheet below. I have the standard text to colum mastered which covers the first 5 columns of lines 1 and 3 (1 $ 513.00 $ 159.39 - Y ), although I have yet to figure out how I can do it with lines hidden (lines 2 and 4 because they do not follow the same denomitator format as lines 1 and 3). The 2nd and 4th lines need to be added to lines 1 and 3. These lines do not vary and need to be split so that "spine; without contrast material" is added after "axial tomography," and "including multiple" needs to be added after "injury to other". Most of the rows are not uniform and the only common denominator that I can determine is the start of the diagnostic codes (number with the decimal point). I hope that I am making sense.

1 $ 513.00 $ 159.39 - Y 72128 Computerized axial tomography, thoracic 959.8 Other & unspecified in]ury to other
spine; without contrast material specified sites, including multiple
1 $ 513.00 $ 159.39 - Y 72131 Computerized axial tomography, lumbar 959.8 Other & unspecified in]ury to other
spine; without contrast material specified sites, including multiple

Here it is...I hope

Sample for Excel Forum.xlsx

It kind of is, just more elaborate. Lines 1 and 3 need to be split in different places and lines 2 & 4 need to be split in different places too. Once this is done, then I can concatenate the lines together as they're supposed to be. The tricky part, is not having a uniform deliminator. Is there a way that I can use the decimal point or the point at which the letters change over to numbers as the deliminator? I also want to send you a huge thank you for trying to help me. I so appreciate it. You're awesome!

I forgot to tell you, it is coming from a PDF conversion of an insurance report.

Hello. My apologies. I should have sent you clearer info. In the spreadsheet I have attached, I have included notes etc. I hope this helps. I tried attaching a copy of a page before it was converted so that you can be familiar with what I am working with, but I could not attach it within the site because it was too big of a file. I do not understand this because I cropped it down to less than half a page. If you like I can e-mail it to you.

Sample for Excel Forum.xlsx

Happy Monday.

Please allow me to clarify, the 2nd part of line 1 belongs at the beginning portion of line 2.

I wanted to follow up to see if anything was able to be done for me and my dliemna. I was unable to follow up prior to today because my husband has had surgery recently and that has put me "behind the 8-ball" as of lately. My apologies.