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

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




wrote in message
oups.com...
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