You might want to add that if you copy a cell with this formula and paste it
to another worksheet, you will get a general protection fault and your
workbook will close losing all unsaved changes. this is in xl2000 and
earlier. I don't believe you get the failure in xl2002 and later.

--
Regards,
Tom Ogilvy



"keepITcool" wrote in message
...
Jon


the "neatest" thing i can come up with involves a named formula.
(this is needed else you cannot call the macrofunctions)


insert a name formula

Name : Splitter
Refersto:

=EVALUATE("={"""&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( SUBSTITUTE(Sheet1!$A1,
" Buy ","|Buy|")," Sell ","|Sell|")," Today at ","|Today at|"),"|",CHAR
(34)&INDEX(GET.WORKSPACE(37),14)&CHAR(34))&"""}")


now
select c1:f1
type =splitter
close with ctrl shift enter.

copy down the array formula as far as you need.

hmm... this IS cool

have fun coding!

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Jon Atkins wrote:

Baked Beans Buy Zeinz Products Today at 10:03:42am
Baked Beans Sell Maru Industries Today at 10:27:32am
Parsnips Buy The Farming Corp. Today at 11:23:57am
Parsnips Sell The Superstore Confed. Today at 12:05:09pm