Assign value for data that starts with a certain letter

[Steve Bostwick]

If the data in a column starts with a certain Number or Letter, how can I get it to put a value in another column?

I have a large database and need to take all the data in a column that starts with the letter P and in a separate column assign it another value.

So for all data that starts with P, in the column specified put the letter N.

Thanks!

[ChemistB]

Let's say your data starts in D2. Then in the other column

=IF(LEFT(D2,1)="P","N", "")
Does that work for you?

[martindwilson]

if its just one leter you could just use find p replace n
or with data in a1
if(left(a1,"p"),a1,"") to extract all those with p
or say
if(left(a1,"p"),"n"&RIGHT(A1,LEN(A1)-1),"")
im not sure if you want to replace p or just identify it tho as chemistb has done

[ChemistB]

Or do you have a series of letters where each one would get a designated letter? In that case, you'd need to set up a nested IF statement (if the list is short) or do a Lookup (if the list is longer).

[Steve Bostwick]

Let's say your data starts in D2. Then in the other column

=IF(LEFT(B2,1)="P","N", "")
Does that work for you?

That's exactly what I was trying to do! Thank you.