Excel Formula

[kipper19]

Looking for some help here
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

 

[kipper19]

Thanks all for your help, much appreciated, will try out your solutions.

 

[kipper19]

Franz,
Using your formula I keep getting an error, even using the cell ranges as per my original example

 

[FranzV]

I forgot to mention you have to select a range that has the same size as your list to input the array formula using CTRL+SHIFT+ENTER.

You can check the sample file to see how it works.

Find (B).xlsx