Re: Breaking out data in a cell
- From: "David Biddulph" <groups [at] biddulph.org.uk>
- Date: Tue, 11 Sep 2007 01:06:05 +0100
The reason why you got zero from Omnicron's formula is that LEFT and MID
return text strings, so to convert to numbers you need to use a trick like
Teethless mama's +0 (or *1) or otherwise precede the LEFT or MID with a
double unary minus --LEFT(... or --MID(...
--
David Biddulph
"Robert Smith" <usirsclt_No_Spam_@xxxxxxxxxxxxx> wrote in message
news:13ebm1j4n7f5hb0@xxxxxxxxxxxxxxxxxxxxx
I'd like to thank everyone for their reply. I tried the first option by
Omnicron, which showed the numbers correctly, but when doing an average on
those numbers, brought up a big fat 0 for each column.
Teethless mama's formulas renders the correct number via an average
formula.
As always folks, thanks for the help.
Bob
"Teethless mama" <Teethlessmama@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:4840066E-7319-4A39-8323-0DFD53CDA008@xxxxxxxxxxxxxxxx
In B1: =LEFT(A1,FIND(" ",A1)-3)+0
In C1: =MID(A1,FIND("^",SUBSTITUTE(A1," ","^",2))+1,LEN(A1))+0
select B1 to C1 and copy down as far as needed
"Robert Smith" wrote:
Hi folks,
I download a lot of stats via web queries. One set of stats includes 100
or
so cells in a single column with random data like "74th of 9354" without
the
quotes. Can someone help me with a formula to break out the separate
numbers
74 & 9354 in the columns to the right, so that I can average those 100
or so
cells?
Thanks for any help you can provide.
Bob
.
- References:
- Breaking out data in a cell
- From: Robert Smith
- Re: Breaking out data in a cell
- From: Robert Smith
- Breaking out data in a cell
- Prev by Date: Re: Breaking out data in a cell
- Next by Date: Re: Eulier Totient Function
- Previous by thread: Re: Breaking out data in a cell
- Next by thread: Re: present value of a future amount
- Index(es):
Relevant Pages
|
Loading
