Concatenate formula help please
 

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

Concatenate formula help please
 

Try this:

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

Copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ferde" wrote in message
...
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

Concatenate formula help please
 

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

"Ragdyer" wrote:

Try this:

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

Copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ferde" wrote in message
...
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

Concatenate formula help please
 

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ferde" wrote in message
...
WORKS PERFECT... Thank you so much for the help.

"Ragdyer" wrote:

Try this:

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

Copy down as needed.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"ferde" wrote in message
...
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