View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Ritthaler Jason Ritthaler is offline
external usenet poster
 
Posts: 1
Default Merging part of one field with another field

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?