If statement query

[Guest]

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?

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[Guest]

Thankyou very much, exactly what i was looking for.

 

[Pete_UK]

Glad it worked for you - thanks for feeding back.

Pete