Text Searching in a Function
Hi,
Try This
=IF(LEFT(A2,1)="C","C","")
TGV
"malvis" wrote:
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
|