Re: Units out of the data.
1. The formula =Value(Left(C1,Find(" ",C1))) will be insensitive to
longer--129.4 km-- or less specific--7 km-- distances.
2. When I remove units from a list, usually I'm working a large
data and find that the whole spreadsheet works better when source
this isn't the result of formula. That is, it doesn't take so long to
refresh when I'm only waiting on 10,000 calculations, and not
So to avoid those annoying long refresh times, instead of creating
source data with formula I copy the column to a new one, ensure there
adequate new columns behind it, then convert the column to data with
-> Text to Columns" and choose to break on space only (in your case,
sometimes I have to list out the first letter of units, but then I
units, so instead I find/replace the new column to introduce tab
before doing the text to column action. (And if you trust yourself to
recognize mistakes in the text to columns steps before "undo" is
copying the column to another one isn't required.)
On Fri, Nov 26, 2021 at 11:12 AM Hylton Conacher (ZR1HPC) <
On 2021/11/26 16:38, Andrew Pitonyak wrote:
Left will return a string so convert to a number using value...
Something like this
THANK YOU Works as expected,now on to the next formula Challenge
Get BlueMail for Android <https://bluemail.me>
On Nov 26, 2021, at 9:12 AM, "Hylton Conacher (ZR1HPC)"
<firstname.lastname@example.org <mailto:email@example.com>> wrote:
Using LO188.8.131.52 <http://184.108.40.206> Calc on iMac 11.6.1(Big
I have a data column that ends in alphabetic letters i.e.
C | D
2| 2.4 km| 2.4
3| 4.8 km| 4.8
As the ' km' can't be added in column C, I used the LEFT
extract the first 3 digits, namely =LEFT(C2,3). This works
in column D, BUT whilst not shown on the spreadsheet, the
shown in-between double quotes if one looks at the formula,
with the Function Wizard, which again does not enable the
added, averaged etc.
Both C, D columns are formatted as Number with a single
and there will be no -ve number.
What am I missing, and where to rectify it?
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more:
List archive: https://listarchives.libreoffice.org/global/users/