This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Belfiore Chi-kin BOKORE chris Bokore Chris BONILLA david Bonilla David CASTILLO dilber Castillo Dilber CHAN esha Chan Esha CHANG farhan Chang Farhan CHEWCHUK frank Chewchuk Frank CHUNG gerlie Chung Gerlie DASTOOR hiroyuki Dastoor Hiroyuki Write An Excel formula that will produce the values in the Last Name column. =LEFT( SURNAME, 1) & LOWER( RIGHT ( SURNAME, LEN( SURNAME) -1 )) or =CONCATENATE( LEFT( SURNAME, 1) , LOWER( RIGHT( SURNAME, LEN( SURNAME) -1 ))) attempts to use MID instead of RIGHT should be assessed for their functionality. F1...
View Full Document
This note was uploaded on 12/16/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.
- Spring '09