Multiple Functions across Two Columns

[planetjk]

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

 

[Peo Sjoblom]

Last names in A2 and first names in B2

=LOWER(RIGHT(A2)&MID(A2,LEN(A2)-1,1)&MID(A2,LEN(A2)-2,1)&LEN(A2)&LEN(B2)&RIGHT(B2)&MID(B2,LEN(B2)-1,1)&MID(B2,LEN(B2)-2,1))

LOWER is just to make it lowercase in case of a name like Ken, if that is
not important you can remove that

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon