What can I use to populate a cell using information in other cells?

[rcabunac]

Hello,

I have not reviewed other posts and am running out of time so I apologize for that.
I need to create ID's based on a prefix and then other criteria within three different cells and only using portions of the data within those cells.
I want to take the first initial of the first name, the first initial of the last name and then the last three digits of a six digit number and append it to a prefix I have auto filled within the cell(s).

EX:
Cell B1 contains FirstName (John)
Cell C1 contains LastName (Smith)
Cell H1 contains six digit number (123456)

I auto fill Cell D1 with a prefix of z001_

Can a formula populate the remaining characters to show the value of z001_js456
Where z001_ is my autofill, j is the first initial of the first name, s is the first initial of the last name and 456 are the last three digits of a numeric code.

I want to be able to do this for any number of rows
Any help is greatly appreciated.

[Russell Dawson]

I think you'd have to have a helper say in E1

=D1&"_"&LEFT(B1,1)&LEFT(C1,1)&RIGHT(H1,3)

[royUK]

maybe

=D1&LEFT(B1,1)&LEFT(C1,1)&RIGHT(H1,3)

[arlu1201]

Or if z001_ will remain static for all rows, then in D1, type

="z001_"&LEFT(B1,1)&LEFT(C1,1)&RIGHT(H1,3)

[Russell Dawson]

Three of a kind!

[rcabunac]

WOW!, you guys rock! I used the last formula cause the prefix is static (or can be changed easily).
This saves me hours of time. Thank you so much all of you!

Anyone have anything for a random password generator that can auto fill cells as well.
Criteria:
Be at least 8 positions in length
Contain a mix of alphabetic and non-alphabetic characters (numbers, punctuation or special characters) or a mix of at least two types of non-alphabetic characters.
Not contain your userid as part of the password

[arlu1201]

Rcabunac,

Please do not mix 2 questions in the same thread. To get better and faster responses similar to this thread, please post in a new thread.

[rcabunac]

Fair enough will post a new thread.

[arlu1201]

Thank you for understanding. Its great you got the solution you needed. Please mark this thread as solved.