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?