Formula for moving part of a name across to another cell

[temiomadeli]

Hi all,

i am trying to work out a formula to move last names across to a different cell from the below table. Please note i can only use formula and cannot use text to columns

Candidate name	Formula
Aaron Holt
Abhishek Wason
Adam Badcock
Adam Brown
Adam Marsden
Adrian Moore
Adrian Wright
Ahmad Refaque
Ahmed Sidot

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

 

[sanrv1f]

Assuming the data is in A2:A10

B2

=MID(A2,SEARCH(" ",A2),LEN(A2))

and copy down

 

[barkercphs]

I am trying to create usernames by pulling the first two letters of column D, the first two letters of column C, and the last three digits of column G. Is there a way to do that?

Thank you.