Thread: Take part data from two fields and auto fill into 3rd field
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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?
Reply With QuoteReply With Quote