How do I find a value in a row in a CSV while using calc?

[bobdobbs]

I’m new to office products generally.

I have a spreadsheet. I have it open in Calc
The document has many rows.
I’d like to locate cells within a row that have:

• either a specific value, or
• a close match to a specific value (like a substring)

[igorlius]

Hi,

try CTRL + H (Search and Replace)

(just leave the replace empty and use Find All, Find prev and Find Next. )

Under Other options, you can define a lot.

Hope that helps.