Hello,

I have a spreadsheet (excel 2007) with many ( a few hundred) lines of text.
Each line is in a single cell (A1, A2, A3, ... ) and is quite long. I want
to split the line into several chunks, with each chunk in a different cell
on the same line. The chunk 'boundaries' can be identified by keywords or
characters, eg *, 'name'. I think this is called parsing ?

Is there a way of doing this easily & quickly for all the lines without
writing a macro?. I have no experience of macros & don't want to spend a lot
of time learning for what will probably be a one-off project.

Hope this makes sense.

Thanks for advice, hints & tips etc

KK