please help with empty spaces
PIRA 3. General $ % Number 8-9 Conditional Format as Cell Formatting Table Styles Delete Format Sort & Fine For Sele BIU AA lipboard Font 5xfx Alignment Styles Cells Editing Date related functions review Today's date : 2/16/2020 Some examples of date functions: TODAY DAY MONTH YEAR DATE Date of birth Date on which person turns 21 years old 12/8/1990 3/1/1996 6/15/1993 11/29/1984 Year in which Person's age today in years person will be 21 years old 1/29/1900 1/23/1900 1/26/1900 2/4/1900 Textile capacity ICE WK2 Text functions Date functions Early Retirement Draw Capter 2. Assignment Home Excel Page Layout Formulas Data -A A = 1 - A- . Developer AutoSave . 2 File Home Insert X Arial B T U - Clipboard - p d Review View General $ % ) Help hache 19 & Share 0 Comm 12 - 2-4 O Conditional Formats Call Formatting Table Styles Font * Sort & Find den 2 ct function Concepts 5 and names of students in a class. You need to extract following information from this using text functions from Ch 2: 6 Just the last name of student 7 Just the First name of student 8 Formatting so that there is a comma and a space between lastname and firstname. For example, Ramirez, Julio 9 Extracting last four digits from a student's class ID. 10 It should say "Happy birthday" if it is a student's birthday today, otherwise should say "Not yet". 11 el formula put the current date so everyday the day would be current 12 2/16/2020 LastName FirstName Last 4 Is student FirstName LastName Date of birth Using MID Using MID digits of Month of Is student's at least 18 using RIGHT using LEFT 13 (DoB) function Name function Last, First class ID function DoB birthday today? years old? function 14 Ramirez 3/11/1992 0580 Ramirez, Anil Not yet 2462 Not yet Brumble 15 11/25/1978 Brumble, Ram 0680 Clark Not yet 8/9/1988 16 Clark, Rays 4120 Not yet Cronkite 17 9/14/1997 Cronkite Jack Davis 4961 2 Happy Birthday 18 2/19/1985 Davis, John Goel 4604 Not yet 19 9/9/1986 Goel, Bonnie Eagan 7161 Not yet 20 10/30/1989 Eagan, Hary Leung 3358 Not yet Bauer 21 9/14/1990 Leung Chris 2001 6 Not yet 22 6/23/1995 Bauer, Maddy 23 ICE WK2 Text functions Date functions Early Retirement Textile capacity U Clipboard LU F Formatting Font Alignment ormatas Cell Table Styles Styles Format - Number B6 Celts B 1 Date related functions review 3 Today's date 2/16/2020 Some examples of date functions: TODAY DAY MONTH YEAR DATE Date of birth Person's age today in years Year in which Date on which person will be 21 person turns 21 years old years old vvvvIVU 12/8/1990 3/1/1996 6/15/1993 11/29/1984 O Textile capacity ICE-W2 Text functions Date functions Early Retirement
