If Cell Begins with a Letter, Output...

[Ocean Zhang]

I need a conditional formula where if the contents in cell A1 begins with "LA" then return a value. It must specifically begin with these 2 letters and not have these 2 letters somewhere else in the string.

example:

lair = true
flair = false
lake = true
blake = false

Thanks!

[NBVC]

Try:

=LEFT(A1,2)="LA"

[MarvinP]

Hi Ocean Zhang,

In A2 put your text string and then do this formula on it.

=AND(LEFT(A2,2)="la",ISERROR(FIND("la",A2,2)))

[Marcol]

What happens in "lalaland"?......

[MarvinP]

My formula give back false in "lala land" as I think the OP wanted.

[Ocean Zhang]

Thanks guys for showing me the "left" function! This worked:

=if(left(a1,2)="la","good","")

Thanks!

[Abbo23]

Thanks guys for showing me the "left" function! This worked:

=if(left(a1,2)="la","good","")

Thanks!

Thank you this was perfect for me and what I'm looking to do.....However I have codes that start with 1 of 3 letters in a column, if they start with e I want say "eggs" returned, if they start with I I want say "India" returned and if they start with V I want say "Voice" returned, is there a way I can extend this formula to have all 3 options covered?
so
=if(left(a1,1)="E","eggs","") then how do I extend this to cover the other two possibilities?
Thanks so much in advance, glad I came across this thread!

[Marcol]

@ MarvinP
I did notice this, just thought I'd prompt the OP

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread