I have two columns of data that I need to extrapolate into another
column. Here are the columns and examples:

[LastName] Smithers
[FirstName] John
[Password] sre84nho

The password consists of:
(the last 3 letters of the LastName, in reverse)+
(the number of letters in the LastName)+
(the number of letters in the FirstName)+
(the last 3 letters of the FirstName, in reverse)

LastName and FirstName are known. I thought I could use normal
functions (RIGHT and LEN) but it's not coming together like I thought.
Is there a way to offset RIGHT or LEFT so that they only display 1
character, X characters from the RIGHT or LEFT? And, is there a way to
have RIGHT display in reverse?

Any thoughts? Am I going about this all wrong? And yes, I realize I'm
not exactly promoting strong password security here. This is for an
offline project. :) Also, I'm not worried about people with names of
10 characters or longer.

Thanks in advance