Declamatory
Active Member
- Joined
- Nov 6, 2014
- Messages
- 319
God morning folks,
I have the following table:
<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:
Thanks and kind regards,
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,