First time here? Check out the FAQ!
asked 2012-09-14 12:24:26 +0200Kenjiro43
I want to create my function in LibreOffice Calc. How do i find text? I couldn't use "FIND()" and "SEARCH()" just like i use in Calc. Did libreoffice have build-in function to find text?
UPDATE: When I call FIND i got error. They said function FIND didn't exist
Dim temp as Integer temp=FIND("-","This-is string")
I got error
answered 2012-09-14 12:28:12 +0200RQuadling
I use FIND() ...
=LEFT(A1, FIND(" / ", A1))
I've just used this function to create a clipped version of a description, truncating the text to the first ' / '.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-14 12:24:26 +0200
Seen: 310 times
Last updated: Feb 23