Formula IF starts with, not contains

[slinky192001]

Hello

I have a the below formula which checks is a cell contains a certain phrase. I want to amend this to only work if the cell starts with the phrase. Can anyone help?

=IF(ISNUMBER(SEARCH("*A3P - SV*",Q2)),"SV",IF(ISNUMBER(SEARCH("*A3P - SP*",Q2)),"SP",IF(ISNUMBER(SEARCH("*A3P - DCS*",Q2)),"DCS",IF(AND(ISNUMBER(SEARCH("*HHU*",Q2)),AI2=0),"HHU",I2))))

Thank You

 

[CharlesChuckieCharles]

=IF(ISNUMBER(SEARCH("*A3P - SV*",Q2)),"SV",IF(ISNUMBER(SEARCH("*A3P - SP*",Q2)),"SP",IF(ISNUMBER(SEARCH("*A3P - DCS*",Q2)),"DCS",IF(AND(ISNUMBER(SEARCH("*HHU*",Q2)),AI2=0),"HHU",I2))))

Replace the leading star's as in
=IF(ISNUMBER(SEARCH("*A3P - SV*",Q2)),"

with

=IF(ISNUMBER(SEARCH("A3P - SV*",Q2)),"

 

[CharlesChuckieCharles]

=IF(ISNUMBER(SEARCH("*A3P - SV*",Q2)),"SV",IF(ISNUMBER(SEARCH("*A3P - SP*",Q2)),"SP",IF(ISNUMBER(SEARCH("*A3P - DCS*",Q2)),"DCS",IF(AND(ISNUMBER(SEARCH("*HHU*",Q2)),AI2=0),"HHU",I2))))

Replace the leading star's as in
=IF(ISNUMBER(SEARCH("*A3P - SV*",Q2)),"

with

=IF(ISNUMBER(SEARCH("A3P - SV*",Q2)),"

or more specifically

OR =IF(LEFT(Q2,len("A3P - SV"))="A3P - SV","SV....
which checks the text of a cell from the left or start


=IF(LEFT(Q2,LEN("A3P - SV"))="A3P - SV","SV",IF(LEFT(Q2,LEN("*A3P - SP*"))="A3P - SP","SP",IF(LEFT(Q2,LEN("A3P - DCS"))="A3P – DCS”,"DCS",IF(AND(LEFT(Q2,LEN("HHU"))=”HHU”,AI2=0),"HHU",I2))))

 

[slinky192001]

Hi,

Thank you, i tried this but it doesnt work, it still picks it up if A3P - SV is in the middle of the string of text.

However, requirements have just changed and I no longer need this.

But thank you very much, always helpful on this forum.

C

 

[energman58]

Not sure what you are trying to do but SEARCH returns the place in teh string where it occurs so

=IF(ISNUMBER(SEARCH("A3P - SV*",Q2)),

Will evaluate True wherever A3P-SV appears in Q2

So you probably need something that looks like this

=IF((ISNUMBER(SEARCH("A3P - SV*",Q2)),if(SEARCH("A3P - SV*",Q2)=1,....

and so on!