Text Searching in a Function
 

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

Text Searching in a Function
 

=IF(left(A2,1)="C",

"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

Text Searching in a Function
 

Hi,

Try This

=IF(LEFT(A2,1)="C","C","")

TGV

"Sean Timmons" wrote:

=IF(left(A2,1)="C",

"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

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