Also that one line of data was split over two lines, and the second Set
was 2 lines shorter than the first, hence my comment that, if possible,
a more standard format would make life easier.

--

PY & Associates Wrote:
You should note that the field before Repair Action #1 is irregular.
Who
knows what surprises lie in other set of data?

"Bryan Hessey"

wrote in message
news:Bryan.Hessey.26kcgy_1145537100.9247@excelforu m-nospam.com...

Just of interest for schnett, the attached formula (across Row 2)
will
show roughly what will be required in specs for parsing your data,
and
I guess highlight the need to, if possible, have the file supplied in
a
set format.

Hope this assists you


File:http://www.excelforum.com/attachment...3&d=1145536793

--

Bryan Hessey Wrote:
Well spotted, I read the question but not the data.

Row 1 appears to be 2 fields, sequence and Model Number but only
one
':' seperator, row 2 has two ':' sperators, row 3 and 4 only one,
whilst others, like the Vendor rates, have none.

Could be an interesting VB parse unless the OP could re-extract
dropping the headers, I cannot see that the data will support any
form
of text-to-columns separation.

--



+-------------------------------------------------------------------+
|Filename: Book1v.zip
|
|Download: http://www.excelforum.com/attachment.php?postid=4663
|

+-------------------------------------------------------------------+

--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=534393



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534393