#### Declamatory

##### Active Member

- Joined
- Nov 6, 2014

- Messages
- 310

I have the following table:

<colgroup><col><col><col><col><col></colgroup><tbody> </tbody> |

<colgroup><col><col><col><col><col></colgroup><tbody>

</tbody>

The columns split out the data from column A.

Formula in B2= =IFERROR(MID(A2,SEARCH(" ",A2,1)+1,SEARCH(" ",A2,SEARCH(" ",A2,1)+1)-SEARCH(" ",A2,1)),"")

Formula in C2= =IFERROR(RIGHT(A2,LEN(A2)-SEARCH(" ",A2,SEARCH(" ",A2,1)+1)),"")

Formula in D2= =IFERROR(LEFT(A2,SEARCH(" ",A2,1)-2),"")

Formula in E2 = =IFERROR(RIGHT(A2,LEN(A2)-SEARCH(" ",A2,SEARCH(" ",A2,SEARCH(" ",A2,1)+1)+1)),"")

Is there a way I can:

- remove the ‘known as’ name and parentheses from the forename column, without using MID in the formula
- remove the parentheses in the ‘known as’ column leaving just the known as name?

Thanks and kind regards,