Ok I am a total newbie on Excel macro'ing and I hope some of you hotshots can
help.

What I am looking for is a macro which:

a) imports an ASCII file ( ; delimeted)
AND (the worse part)
b) the last 2 colloms contain a string which holds together multiple fields.
Those fields are seperated by values as #BR1# (meaning Begin Record 1) and
#VV1# (dutch Volgend Veld 1 or.. Next Field 1). The next 'record' within the
colom will start with VR1 (dutch Volgend Record or Next Record) unitl all
'records' are handled in that colom. The colom will be closed with an ER1
(End Record)

are you having fun? Cause I certainly am not; I have absolutely no clue how
to handle this. Find and replace is one thing.. but it has it's limitations.

I hope someone can come up with a nice idea how to tackle the *******,

cheers in advance,

Archie