LibreOffice Calc SEARCH and FIND functions

Posted by TTT on Super User See other posts from Super User or by TTT
Published on 2012-06-20T12:00:37Z Indexed on 2012/06/20 15:18 UTC
Read the original article Hit count: 374

Filed under:

I am trying to process some data in Calc. One of the steps involve finding if a certain string is part of one of the column. I tried using FIND and SEARCH functions. Both behave in the same way and I am not getting correct results.

E.g. Say I have following strings in Column A

NY
SF
LON
CAN
US

and am trying to put following formula in column C

=SEARCH("NY",A2)

The result is - cell C2 will have 1 (which is correct) but if the same formula is copied to other cells in column C - it gives me "#VALUE!" error and I am unable to find out why ?

Any one has any ideas ?

Thanks in advance

TT

© Super User or respective owner

Related posts about libreoffice-calc