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
|