Taking data from 3 columns to make the fourth.

I have three columns of data: first name, middle name, last name. I want to
make a fourth column that contains the first letter of the first and middle
name and the entire last name to make a fourth column. example: john edward
smith in the first column and the fourth column would be jesmith.

thanks in advance.
--
Jerry

I meant to say.....

I have three columns of data: first name, middle name, last name. I want to
make a fourth column that contains the first letter of the first and middle
name and the entire last name to make a fourth column. example: john edward
smith in the first three column and the fourth column would be jesmith.

--
Jerry

"Jerry Arnone, PMP" wrote:

> I have three columns of data: first name, middle name, last name. I want to
> make a fourth column that contains the first letter of the first and middle
> name and the entire last name to make a fourth column. example: john edward
> smith in the first column and the fourth column would be jesmith.
>
> thanks in advance.
> --
> Jerry

Hi!

Try this:

=LEFT(A1,1)&LEFT(B1,1)&C1

Biff

"Jerry Arnone, PMP" <jarnone@bellsouth.net> wrote in message
news:4EFC742D-E7E5-4F89-9292-DFCD8F737135@microsoft.com...
>I meant to say.....
>
> I have three columns of data: first name, middle name, last name. I want
> to
> make a fourth column that contains the first letter of the first and
> middle
> name and the entire last name to make a fourth column. example: john
> edward
> smith in the first three column and the fourth column would be jesmith.
>
> --
> Jerry
>
> "Jerry Arnone, PMP" wrote:
>
>> I have three columns of data: first name, middle name, last name. I want
>> to
>> make a fourth column that contains the first letter of the first and
>> middle
>> name and the entire last name to make a fourth column. example: john
>> edward
>> smith in the first column and the fourth column would be jesmith.
>>
>> thanks in advance.
>> --
>> Jerry

Jerry

=LEFT(A1,1)&LEFT(B1,1)&C1 entered in D1 and copied down column D.


Gord Dibben Excel MVP


On Mon, 23 May 2005 19:24:01 -0700, "Jerry Arnone, PMP"
<jarnone@bellsouth.net> wrote:

>I meant to say.....
>
> I have three columns of data: first name, middle name, last name. I want to
> make a fourth column that contains the first letter of the first and middle
> name and the entire last name to make a fourth column. example: john edward
> smith in the first three column and the fourth column would be jesmith.