taking characters from last name and first name to create a pa
=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
|