Quick LibraOffice calc help please

[audi321]

Hi all, I only have access to LibraOffice Calc at the moment, and I cannot find the function 'TEXTBEFORE' which I regularly would use in Excel.

I want to choose all text from a cell before a comma, for example "03/22/23, blah blah blah", and I only want to return "03/22/23" in another cell. Problem is the piece before the comma changes in length - ie. it could be "3/2/23, blah blah" so I cannot simply use =LEFT(A1,6) as the 6 changes too often in length.

Any ideas what I can do? LibraOffice has it's limitations grrrrr

[21TonyK]

has is it got FIND to locate the "," or INSTR ?

[Mr Pointy]

Could you use the SPLIT function with the comma as the delimiter

Split (Text As String, delimiter, number)

https://help.libreoffice.org/6.2/en-US/text/sbasic...

[audi321]

That looks a bit too complex for me. Can anyone think of an alternative (easier) option?

Thanks again for any help.

[nd0000]

You have to do something like LEFT(A1, FIND(A1, ",") - 1)