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