[Solved] FIND Function from Excel not working in OO

[larkinp]

Hey all,

I am new to OO, and have a command that works in Excel and not Calc.

=left(A1,find(",",A1)-1)

This will read cell A1 and take everything from the left of the comma. (And not include the comma) I cannot get this to work in Calc. I assume it is just a wacky syntax thing, but i cannot figure it out. Anyone help?

cheers**
pete

[Villeroy]

Just open your xls in Calc file and see how it converts the formula syntax. Mainly the semicolon as list-separator and the dot as sheet-separator.
=SUM(Sheet1!A1,Sheet1!A2) [in English Excel] becomes
=SUM(Sheet1.A1;Sheet1.A2) [in all Calc versions, independent from language]

...I cannot get this to work in Calc...

This would not help in more complex situations. You should mention what happens (error #NAME).

[larkinp]

I got it

=LEFT(A1;FIND(",";A1)-1)

I missed a semicolon conversion.