Merging part of one field with another field

[Jason Ritthaler]

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?

 

[Guest]

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

 

[Frank Kabel]

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

 

[Peter Beach]

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.

HTH

Peter Beach