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: 376
libreoffice-calc
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