| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy field settings of a field to other fields in same pivot tbl | Excel Worksheet Functions | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
| Auto data fill in | Excel Worksheet Functions | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Auto-Fill in List Fields? | Excel Worksheet Functions | |||
Hybrid Mode
