Formula help please

I have two columns of text. One column has Text A and Text B in each cell (AB) and one column has Text B. Each row has a different value for AB and B how do I write a formula so that I can get text A...