I am trying to use the function"=SEARCH(F1916;"#";1)" in OpenOffice Calc, but it returns an error #Value to search...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
for the occurrence of # in a string. This error is not defined in Help. What does it mean? How can I fix this?
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
Dig Deeper on Enterprise Linux applications and databases
Related Q&A from Solveig Haugland
An office suite expert describes how to use ODBC with OpenOffice 2.0.continue reading
An office suite expert describes where to find information on OpenOffice 2.0's use in the enterprise worldwide.continue reading
An office suite expert tells how to save office templates in one office suite, Oxygen Office Professional 2.0.4., for a user considering an upgrade ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.