Concatenate formula help please

[ferde]

A B C D
04 Brown 40987321 04bro*0987321
05 Smith 40983476 05smi*0983476


For security reasons I need to concatenate columns A & B & C to equal Column
D.

Is there a formula I can use to accomplish this?

Thank you in advance for your help
Deb

 

[Ragdyer]

Try this:

=A1&LOWER(LEFT(B1,3))&"*"&RIGHT(C1,7)

Copy down as needed.

 

[ferde]

WORKS PERFECT... Thank you so much for the help.

Try this:

=A1&LOWER(LEFT(B1,3))&"*"&RIGHT(C1,7)

Copy down as needed.

 

[Ragdyer]

You're welcome, and thank you for the feed-back.