In Calc, is there a formula to find a text (like “hello”) in a range of cells and return the row number of the first occurrence?
Don’t think this should be closed as accepted answer is not quite right. OP wants to search a range of cells and get row of first match and doubt SEARCH function is doing that. My answer would be to use MATCH function as it’s doing exactly that:
i want to search a text and then show the row.
match its not working, vlookup and hlookup either
Are you askling for the SEARCH function? Text Functions - LibreOffice Help
Also you may refer to Calc Guide Appendix (B) for Functions: