If statement query
 

In a column i have some values starting with "TBA, AAA, BBB 123" . If the
string begins with TBA, then i want to return TBA in another cell. else i
want to return the value "Existing". Is there a function i can use to do this?

If statement query
 

Try this:

IF(LEFT(TRIM(A1),3)="TBA","TBA","Existing")

Hope this helps.

Pete

On Apr 20, 9:38 am, Rajula wrote:
In a column i have some values starting with "TBA, AAA, BBB 123" . If the
string begins with TBA, then i want to return TBA in another cell. else i
want to return the value "Existing". Is there a function i can use to do this?

If statement query
 

Thankyou very much, exactly what i was looking for.

"Pete_UK" wrote:

Try this:

IF(LEFT(TRIM(A1),3)="TBA","TBA","Existing")

Hope this helps.

Pete

On Apr 20, 9:38 am, Rajula wrote:
In a column i have some values starting with "TBA, AAA, BBB 123" . If the
string begins with TBA, then i want to return TBA in another cell. else i
want to return the value "Existing". Is there a function i can use to do this?

If statement query
 

Glad it worked for you - thanks for feeding back.

Pete

On Apr 20, 10:36 am, Rajula wrote:
Thankyou very much, exactly what i was looking for.



"Pete_UK" wrote:
Try this:

IF(LEFT(TRIM(A1),3)="TBA","TBA","Existing")

Hope this helps.

Pete

On Apr 20, 9:38 am, Rajula wrote:
In a column i have some values starting with "TBA, AAA, BBB 123" . If the
string begins with TBA, then i want to return TBA in another cell. else i
want to return the value "Existing". Is there a function i can use to do this?- Hide quoted text -

- Show quoted text -