How to extract text strings of only cell starting with specific character

[Nayasoch]

Hello Everyone,
I have searched for solution for few hours but couldn't find any. I have few text strings of variable length. I would like to extract content of cell that starts with certain specific Character.
For Example
I have A1:A3

Batman vs superman 4:50
Wonder woman vs Flash 5:60
Batman vs Aquaman 6:90

Now If I want to extract text string of cell starting with letter B. Then I expecting result in B1:B3 as,

Batman vs superman 4:50

Batman vs Aquaman 6:90

i.e B2 is empty and B1 and B2 will be filled with cell content of A1 and A3.

Any help guys??

 

[Scott T]

Excel 2010
	A	B
1	Batman vs superman 4:50	Batman vs superman 4:50
2	Wonder woman vs Flash 5:60
3	Batman vs Aquaman 6:90	Batman vs Aquaman 6:90
Sheet1

Cell Formulas
Range	Formula
B1	=IF(LEFT(A1,1)="b",A1,"")
B2	=IF(LEFT(A2,1)="b",A2,"")
B3	=IF(LEFT(A3,1)="b",A3,"")

 

[Nayasoch]

Thanks Scott T. Exactly what I was looking for.