[Solved] Identify presence of text in a cell

Discuss the spreadsheet application
Post Reply
edinflorida
Posts: 4
Joined: Mon Dec 26, 2022 2:27 pm

[Solved] Identify presence of text in a cell

Post by edinflorida »

I have this data
1920 date; originally long frame 1906 Navy; rebarreled w/ short receiver
If 1920 is anywhere in the specific cell I would like "True" to be returned.

Thank you
Last edited by Hagar Delest on Fri Apr 05, 2024 11:25 pm, edited 1 time in total.
Reason: tagged Issue.
openoffice 4.1.11 on Win 11
Top
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Identify presence of text in a cell

Post by Villeroy »

=ISNUMBER(FIND("1920";A1))
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Top
edinflorida
Posts: 4
Joined: Mon Dec 26, 2022 2:27 pm

Re: Identify presence of text in a cell

Post by edinflorida »

Thank you.
openoffice 4.1.11 on Win 11
Top
Post Reply

Return to “Calc”