Thank you, yes, every new section starts with ======PDI, and the columns
you mentioned are what I'm seeking. In actuality, the original raw text
starts with from 10 to 50 (varying) lines of info-text that lead up to
the first "======PDI". As an aside, I wrote the following macro to
delete those lines.
______________________________
Public Sub deleterows()
' deletes the headers leading up to the first =====PDI=====
Dim selection As range
Set selection = Cells.Find(what:="PDI", lookat:=xlPart)
range("a1").EntireRow.Select
Do Until ActiveCell.Value = selection
ActiveCell.EntireRow.Delete
Loop
End Sub
__________________________________


--
AwkSed2Excel
------------------------------------------------------------------------
AwkSed2Excel's Profile: http://www.excelforum.com/member.php...o&userid=23464
View this thread: http://www.excelforum.com/showthread...hreadid=374110