Quick LibraOffice calc help please
Discussion
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
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
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...
Split (Text As String, delimiter, number)
https://help.libreoffice.org/6.2/en-US/text/sbasic...
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff