2014 Archives by date, by thread · List index

# 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

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

### Context

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.