Text Searching in a Function

M

malvis

Let's say I have one column with data like this: C012

But all I want to do is return all cells in that column that start with "C"
(there are many cells that start with other letters).

I want to use an IF formula that looks at only the first letter in these
cells.

Maybe it would look like this: =IF(A2="C###", but that doesn't work.
Is there a placeholder and format so it only looks at the first letter?

Thanks, Matt
 
Top