Using search in OpenOffice Calc

I am trying to use the function"=SEARCH(F1916;"#";1)" in OpenOffice Calc, but it returns an error #Value to search for the occurrence of # in a string. This error is not defined in Help. What does it mean? How can I fix this?

    Requires Free Membership to View

    Login

    When you register, my team of editors will also send you resources covering Linux administration and management; integration and interoperability between Linux, Windows and Unix; securing Linux and mixed-platform environments; and migrating to Linux.

    Margie Semilof, Editorial Director

    By submitting your registration information to SearchEnterpriseLinux.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchEnterpriseLinux.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

The SEARCH function returns the position of a string within another string. For instance, searching for 54 within the string 123454678 returns the position 5 since 54 starts at the fifth position. FIND returns the same information. You can't search for the target within a range of cells. Also, the return value is simply the place within the search target where the searched-for item is found.The syntax for both is within the online help.

From what I can tell, #Value means that the thing you're searching for was not found in the location it was told to search. To search for # within a cell E8 and return the position at which it starts, the syntax would be
=SEARCH("#";E8)

This was first published in October 2007

Back to top