Copy part of multiple cells to another cell

[barkercphs]

I am trying to create usernames for column F by selecting the first two letters of column D, the first two letters of column C, and the last three numbers of column A.

For example:

John Doe

ID: 1234567


Username: Jodo567

Thank you!

 

[WarPigl3t]

=Left(D1,2)&Left(C2,2)&Right(A1,3)