Re: Splitting cell contents
From: keepITcool (xrrcvgpbby_at_puryyb.ay)
Date: 09/25/04
- Next message: Neil K: "reading data from com port into excel spread***"
- Previous message: Bob Phillips: "Re: Newbie needs help with if statement"
- In reply to: Jon Atkins: "Splitting cell contents"
- Next in thread: Tom Ogilvy: "Re: Splitting cell contents"
- Reply: Tom Ogilvy: "Re: Splitting cell contents"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 25 Sep 2004 01:51:50 -0700
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 <jonatkins@ntlworld.com> 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
- Next message: Neil K: "reading data from com port into excel spread***"
- Previous message: Bob Phillips: "Re: Newbie needs help with if statement"
- In reply to: Jon Atkins: "Splitting cell contents"
- Next in thread: Tom Ogilvy: "Re: Splitting cell contents"
- Reply: Tom Ogilvy: "Re: Splitting cell contents"
- Messages sorted by: [ date ] [ thread ]
