I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3

didn't type this in and test, but try this:

mid(A1,1,1) & mid(B1,1,3) & Trim(int(RND(0)*10))

something like that anyway...



"Juan" wrote:

I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3

Hi

=LEFT(B1,1)&LEFT(A1,3)& RANDBETWEEN(1,9)

Regards,
Per

"Juan" skrev i meddelelsen
...
I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3

=Left(B1,1)&left(A1,3)&trunc(rand()*9+1)

but each time you calculate, the number will change.

--
Regards,
Tom Ogilvy



"Juan" wrote:

I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3

Since you posted this in a programming newsgroup, I'm assuming you want VB
code...

PW = Left(Range("B1"), 1) & Left(Range("A1"), 3) & (Int(10 * Rnd()) + 1)

Rick


"Juan" wrote in message
...
I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3

=LEFT(B1,1)&LEFT(A1,3)&MID(RAND(),3,1)

What's RANDBETWEEN? Not in Excel 2003

"Per Jessen" wrote:

Hi

=LEFT(B1,1)&LEFT(A1,3)& RANDBETWEEN(1,9)

Regards,
Per

"Juan" skrev i meddelelsen
...
I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3

What's RANDBETWEEN? Not in Excel 2003

It requires the Analysis ToolPak add-in to be loaded.

Rick

Thanks Tom, Per and Charlie. All of yours work perfectly. This made things so
much easier for me.

"Juan" wrote:

I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3

Just a heads up,

Int(10 * Rnd()) + 1

generates random numbers between 1 and 10 inclusive vice the 1-9 asked for.

--
Regards,
Tom Ogilvy


"Rick Rothstein (MVP - VB)" wrote:

Since you posted this in a programming newsgroup, I'm assuming you want VB
code...

PW = Left(Range("B1"), 1) & Left(Range("A1"), 3) & (Int(10 * Rnd()) + 1)

Rick


"Juan" wrote in message
...
I need to create a password based on the first letter of the first name and
the first 3 letters of the last name along with a random number 1-9 at the
end. How can i do this? C1 below is where i want to enter the formula to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3

I guess I typed that too fast... thanks. Although, based on his last
posting, the OP appears to not want a VB solution (even though he posted to
a programming newsgroup), here is the corrected formula for the archives...

PW = Left(Range("B1"), 1) & Left(Range("A1"), 3) & (Int(9 * Rnd()) + 1)

Rick


"Tom Ogilvy" wrote in message
...
Just a heads up,

Int(10 * Rnd()) + 1

generates random numbers between 1 and 10 inclusive vice the 1-9 asked
for.

--
Regards,
Tom Ogilvy


"Rick Rothstein (MVP - VB)" wrote:

Since you posted this in a programming newsgroup, I'm assuming you want
VB
code...

PW = Left(Range("B1"), 1) & Left(Range("A1"), 3) & (Int(10 * Rnd()) + 1)

Rick


"Juan" wrote in message
...
I need to create a password based on the first letter of the first name
and
the first 3 letters of the last name along with a random number 1-9 at
the
end. How can i do this? C1 below is where i want to enter the formula
to
create the password.
thanks.

Example:
A1 B1 C1
LN FN New Password
Smith John Jsmi3