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