Take part data from two fields and auto fill into 3rd field
 

needing to know how to take pieces of data from other fields and auto fill
into a 3rd field. For example, field one is First Name, Field Two is Last
Name, Field three is first two digits of first name followed by first three
digits of last name. How can I automatically create a formula to have excel
create this for me?

Take part data from two fields and auto fill into 3rd field
 

A1: Tethless
B1: mama

In C1: =LEFT(A1,2)&LEFT(B1,3)


"Kevin K" wrote:

needing to know how to take pieces of data from other fields and auto fill
into a 3rd field. For example, field one is First Name, Field Two is Last
Name, Field three is first two digits of first name followed by first three
digits of last name. How can I automatically create a formula to have excel
create this for me?