Re: [libreoffice-users] Access value separated by a comma

On Sat, Aug 9, 2014 at 9:03 PM, Alan B <aboba0@gmail.com> wrote:
> On Sat, Aug 9, 2014 at 9:29 PM, Wade Smart <wadesmart@gmail.com> wrote:
> > Im working on a sheet that has numbers for a sports club.
> > At the moment we use two columns and at the end of
> > the columns of data, we calculate values in one column
> > leaving another empty.
> >
> > What I would like to do is move to a single column design.
> >
> > What I would like to do is:
> > B3=3,7
> > B4=0,10
> > B5=1,2
> >
> > How would I access the first or second value a pair value?
>
>
>  Wade, I believe you will be stuck with messy formulas if you move to a
> single cell. Once you put 3,7 into a cell it is now treated as text, not a
> number. So to use in a number formula it must be converted to a number.
>
> Since you will use a comma to separate your numbers you have a reliable
> separator to pick out the first or second number.
>
> A formula to get the fist number from B3 would be
> =VALUE( MID(B3,1,SEARCH(",",B3)-1))
> The above formula will give you the number 3 which you can then use in your
> other calculations.
>
> A formula for the second number would be
> =VALUE(RIGHT(B3,LEN(B12)-FIND(",",B3)))
> It will you the number 7 which again can be used in your other formulas.
>
> Others may suggest better formulas. I think most will recommend a different
> spreadsheet design.

I was afraid of that.
Ok.. it was just something I was working on. I can stick with two columns
until I find a better way.

Thanks :D

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted