I'm trying to merge part of one field with another field.

What I have is 3 columns. Column A = First Name, Column B
= Last Name, Column C = Shortname.

Example. Column A = Jason, Column B = Ritthaler, Column C
= JRitthaler. I'm taking the first letter of column b,
and combining it with Column C.

Is there a way to program this so it will automatically
populate column C?

I wrote the wrong thing for the example
.. I'm taking the first letter of column A, and all of
column B and combining them into Column C
-----Original Message-----
I'm trying to merge part of one field with another field.

What I have is 3 columns. Column A = First Name, Column
B
= Last Name, Column C = Shortname.

Example. Column A = Jason, Column B = Ritthaler, Column
C
= JRitthaler. I'm taking the first letter of column b,
and combining it with Column C.

Is there a way to program this so it will automatically
populate column C?
.

Hi
in C1 enter
=LEFT(A1,1)&B1

--
Regards
Frank Kabel
Frankfurt, Germany


Jason Ritthaler wrote:
I'm trying to merge part of one field with another field.

What I have is 3 columns. Column A = First Name, Column B
= Last Name, Column C = Shortname.

Example. Column A = Jason, Column B = Ritthaler, Column C
= JRitthaler. I'm taking the first letter of column b,
and combining it with Column C.

Is there a way to program this so it will automatically
populate column C?

Hi Jason,

How about a spreadsheet formula like:

IF(AND(LEN(A1)0,LEN(B1)0),LEFT(A1,1)&B1,"")

Just copy it down for more cells than you are ever likely to have and you
will see the merged name appearing as soon as you enter data in cols A and
B.