In cell A1 I have the number 2, and cell B1 I have the name John (B)

In cell A2 I have the number 3, and cell B2 I have the name Jim

In cell A3 I have the number 4, and cell B3 I have the name June (B)

I'm looking for a formula to find names with the (B) after them then copy the number and name to a different cell etc