Merging part of one field with another field

J

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?
 
G

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
 
P

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
 
Top